Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Works now when the expression is in a variable