4 Replies Latest reply on Oct 4, 2016 11:31 PM by Rohan Malusare

    Calculation for YTD range

    Rohan Malusare

      Hi Experts,

      I am facing difficulties in building logic for  YTD range.

      To control dashboard I am using 2 parameter as follows :

      Parameter for Financial year.(String Format) (Added from Table)

         Parameter for Month (Date Format) (Added from Table)

       

      I am using this calculation but it is not giving expected output of YTD range.

      [Date Month]>=[Date Finyr] and

      [Date Month]<=DATEPARSE('yyyyMM',(if INT([Param_Months])<=3/01/2016 then STR(INT(LEFT([Param_financial_year],4))+1) else LEFT([Param_financial_year],4) END) +[Param_Months])

       

      Can someone guide me on the same?

      Thanks in advance.