Ignore Filter Settings

[#1]

Hello

I wan't to ignore one filter which I want to set on a certain value.

So I got:

sum(if(Year=$(vLastYear) AND PeriodID = ($(vActualPeriodID)-12) AND Stage = ('S')))/1000000

And I want just to ignore the filter settings for Year but keep it on vLastYear.

I tried with sum({1<Year=E(Year), PeriodID <= {($(vActualPeriodID)-12)}, Stage ={('S')}>}) but that didn't work

Anyone got a idea how to this working

Thanks

Peter

[jagan · Accepted solution]

Hi,

If you want to consider the other filters then remove 1 in set analysis like below

sum({<Year={'$(vLastYear)'}, Stage ={'S'}>} MeasureName)

Regards,

Jagan.

[#3]

Works now when the expression is in a variable