4 Replies Latest reply on Jan 22, 2018 2:42 AM by Niranjan Banarjee

    Calculation help

    Niranjan Banarjee

      Hi,

       

      I am trying to segregate manufacturer level data for which i used the below formula and is giving me correct result aggregating entire time period:

       

      { FIXED [Country Display],[Calendar Period],[Modality Display],[Channel Display] :sum((IF [Manufacturer-China[Top-6]]] = [Select Manufacturer] THEN [Measurements] else 0 END))}

       

      But, If I try to only consider YTD 2017 with the help of below formula:

       

      (IF DATEDIFF('year',[Calendar Period],[Ending Date])=0 AND MONTH([Calendar Period])<=MONTH([Ending Date]) THEN [Aggregate Manufacturer Data]END)

       

      Seems some issue with the time period Please help me in fixing it.