4 Replies Latest reply on Sep 14, 2016 1:02 PM by tanya.kanwar.0

    QTD Issue while using parameters

    tanya.kanwar.0

      Hi,

       

      I have a month parameter "T1_Month Selection" that takes derive its value from Report date and another parameter called "Views" where user can select Monthly,QTD and YTD value.

      And my fiscal year is set to Nov.

      I have a calc field to calculate the actuals based on the two parameters user select. The calc field has belowformulae:

      If [Views]="Monthly"

      then

      (

      if [Report Date]<= [T1_Month Selection]

      and

      DATEDIFF('month',[Report Date],[T1_Month Selection])=0

            then [Actual]

      END

      )

      ELSEIF [Views]= "QTD"

      then

      (

      if [Report Date]<= [T1_Month Selection]

      and

      DATEDIFF('quarter',[Report Date],[T1_Month Selection])=0

            then [Actual]

      END

      )

      ELSEIF [Views]= "YTD"

      then

      (

      if [Report Date]<= [T1_Month Selection]

      and

      DATEDIFF('year',[Report Date],[T1_Month Selection])=0

            then [Actual]

      END

      )

      END

       

      I created a sample workbook. When my user selects monthly, it should display monthly value and for QTD, Nov, Dec and Jan as Qtr1( have set the fiscal year to Nov) .

      Can anyone help..?