Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Instead of Today() use your date field to create the variable.
HTH
Sushil
I can't since my date field is till december 2013.
do one thing:
1. create a text box and put your variable to see the value: =vCurrentMonth
now try to select the jab,feb in your fields..
the value in text box will not change because your slection not at all related to your dataset..
Try to get some other way to get the variable value..
HTH
Sushil