3 Replies Latest reply on Jul 30, 2018 7:46 PM by Helen Wang

    How to build double calcualtion

    Helen Wang

      Hi All,

       

      I have created two calculation: "Q3 MGT DA$" and "Q3 Last Cycle$"

       

      Formulas are below and the result is correct:

       

      Q3 MGT DA$:

      ZN(IF str(DATEPART('year',[Fiscal Quarter] ))= '2018' AND str(DATEPART('quarter',[Fiscal Quarter] )) ='3'

      THEN [$ Ship Final Act-Fcst]

      END)

       

       

      Q3 Last Cycle$:

      ZN(IF str(DATEPART('year',[Fiscal Quarter] ))= '2018' AND str(DATEPART('quarter',[Fiscal Quarter] )) ='3'

      THEN [$ Last Cycle Published Ship Fcst]

      END)

       

      I want to create another filed which is:

      Q3 Changes$:

      sum([Q3 MGT DA$])-sum([Q3 Last Cycle$])

       

      but the result is not correct, then I used fixed methodology it is still not correct:

      { FIXED [Region],[GL Country Group],[Product Category],[Product Family],[Product Line], [SKU]: sum([Q3 MGT DA$])-sum([Q3 Last Cycle$])}

       

      Could anyone please give me any advice??

       

       

      Thanks,

      Helen