3 Replies Latest reply: Jun 8, 2010 7:00 AM by Anatoly Pyatygo RSS

    Set Analysiss

    Jandr? Killian



      Can someone please change this to set analysis. I have been battling for probably an hour and i can't seem to get it Right.

      This is for a CY MTD Calculation on sales.

      sum(IF(Year = Year(Today()),IF( MonthNumber >= 01 and MonthNumber <= Num(Month(Today())),Sales)))