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?