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

    Set Analysiss

    Jandré Killian

      Hi

       

      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)))

       

      Thanks,