6 Replies Latest reply on Sep 26, 2018 3:48 PM by Angela Blackburn

    Date calculations using MM YYYY Only

    Angela Blackburn

      I am trying to fix a dashboard that has rolling months built into the calculations.  First I need to get my parameter swappers to work.

       

      The field [Fiscal Date] is already formatted as a Date Dimension with the format 'May 1 2016' for example.

      The field [FTS Paid] is a Measure.

       

      I am trying to do a simple calculation.

       

      Here is my FTS Paid 1-24 Calculation:

      sum(IF [Fiscal Date]  >= dateadd('month',-1,TODAY()) and [Fiscal Date]  <= dateadd('month',-24,TODAY())

      THEN [FTS Paid] else 0 END)

       

      However when it keeps returning 0.

      What am I doing wrong?