Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello.
I have the following formula. How can i rewrite this without the data change from current selection that the user is doing ?
Sum({<SALES_YEAR={'$(=MAX(SALES_YEAR))'},SALES_MONTH={'$(=VMONTH)'},FORMAT={'FRANC'},SALES_DATE=>}AMOUNT)
Thank you in advance.
Try this:
Sum({1<SALES_YEAR={'$(=MAX({1}SALES_YEAR))'},SALES_MONTH={'$(=VMONTH)'},FORMAT={'FRANC'},SALES_DATE=>}AMOUNT)
Might need {1} within VMONTH variable also.
I'm a bit confused, are you saying you want to ignore the user selections?
If that's the case, put a 1 in the beginning of the set analysis
Sum({1<SALES_YEAR={'$(=MAX(SALES_YEAR))'},SALES_MONTH={'$(=VMONTH)'},FORMAT={'FRANC'},SALES_DATE=>}AMOUNT)
Hello David.
I have already put this in the formula but i have the same results. It takes also the selections of the users
Try this:
Sum({1<SALES_YEAR={'$(=MAX({1}SALES_YEAR))'},SALES_MONTH={'$(=VMONTH)'},FORMAT={'FRANC'},SALES_DATE=>}AMOUNT)
Might need {1} within VMONTH variable also.
And might for VMONTH also..