Set analysis

[geogou1973]

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.

[Anonymous]

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)

[geogou1973]

Hello David.

I have already put this in the formula but i have the same results. It takes also the selections of the users

[sunny_talwar · Accepted solution]

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.

[MK_QSL]

And might for VMONTH also..