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.
Hi,
Try like this
sum({1<Year={'$(vLastYear)'}, PeriodID = {'<=($(vActualPeriodID)-12)'}, Stage ={'S'}>} MeasureName)
Hope this helps you.
Regards,
Jagan.
Guess it would be as below
sum({1<Year=, PeriodID = {'<=($(vActualPeriodID)-12)'}, Stage ={'S'}>} MeasureName)
Please provide more information about this.
Thanks,
Sri
No,
this gives always 0,0 as value, independet from all filter settings
No dosn't work,
it gives me 0,0 as value, independent from all filter settings
Okay the problem is the periodID, without this it works
Okay the problem is the period id, without it it works
Hi,
What is the format of your Period id? If you are ok without it then close this thread.
Regards,
Jagan.
But this filter settings ignores all other settings also, but all others then these three shall have an effect
But this filter settings ignores all other settings also, but all others then these three shall have an effect