2 Replies Latest reply on Oct 27, 2018 8:22 AM by minc650

    Not sure if the logical calculated field is correct or not?

    minc650

      Hello,

      I'm stuck on the calculated field. I think the syntax is right. But the data doesn't show. It shows 'Null'.  Please see the screen shot. I want to get the date difference (Milestone Date) between Contract and G Live in C/D Substantial Completion (Milestone Name)  in C/D Substantial completion of Duration Type per each project id. My calculated field is below. Thank you very much.

       

      DC.jpg

       

       

      IF [Duration Type] = 'C/D Substantial Completion' THEN

      DATEDIFF('day',

                (IF ([Schedule Type ] = 'Contract' AND [Milestone Name] = 'C/D Substantial Completion') THEN [Milestone Date] END),

                (IF ([Schedule Type ] = 'G Live'     AND [Milestone Name] = 'C/D Substantial Completion') THEN [Milestone Date] END))

       

       

      END