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

    Calculation help

    Niranjan Banarjee



      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.