9 Replies Latest reply: Jan 9, 2017 12:18 PM by Archana P RSS

    Using variables in set analysis

    Archana P

      Hello: I am trying to pull data for same month for the current and the previous years.

       

      Current Fiscal Year and year to date data:
      My Expression: Sum for Current year -

      =SUM({<FY={$(vMaxFY)},Month={<=$(vPrevMonth)}>}[Volume Received])

       

      Previous Fiscal Year and  year to date data:

      My Expression: Sum for Previous year - the bold part is not working. If I remove "<=" it is pulling the last month data.

      =SUM({<FY={$(vPriorFY)},Month={<=$(vPrevMonth)}>}[Volume Received])

       

      When I add the "<=" in my formula it is not working. I changed the value to Month Number from Long Name in the variable and still no luck.

      Hope my question makes sense :-) Any help is greatly appreciated. Thank You.

       

      Best Regards,
      Archana