3 Replies Latest reply: Jun 5, 2013 12:35 PM by Sushil Kumar RSS

    not Larger than current date in Set analysis

    Aissam Boumejjane

      Hi Guys,

       

      I have sales budget for a whole year. I would like to display the budget until the current month instead of a whole year.

       

      I created a variable vCurrentMonth: =num(Max(month(Today())),00)

      I used that variable to create the following expression:

       

      =sum({<Month={"<$(vCurrentMonth)"}>} Budget).

       

      I noticed that the budget sums everything till may. Which is good! However, when I selected jan., feb. march it ignores my selection.

       

      What am I doing wrong?

       

      Regards,

       

      Sam