Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi There,
I would like the below formula to change only when the "Grouping High" field is selected.
Any other filter selection don't have to affect the final aggregation.
I tried to close the square brackets and add + $<GROUPING_HIGH equals to any selection.
Sum({1<
PERIOD ={'$(vCurrentPeriod)'},
IN_BUDGET = {'Y'},
TYPE = {'ACTUAL'}> +
$<GROUPING_HIGH = {'Better Workplace'}>}
SAVINGS)/1000000
This doesn't seem to be working at the moment, the figure doesn't change when I select a different filter
Is there a way to achieve this without creating a variable?
thank you
Not sure of without actually testing it but you may try this -
Sum({1<
PERIOD ={'$(vCurrentPeriod)'},
IN_BUDGET = {'Y'},
TYPE = {'ACTUAL'},GROUPING_HIGH = P(GROUPING_HIGH>}
/1000000
No unfortunately this doesn't solve it...
There was a typo, hope you added missing ')' in the P function..
Sum({1<
PERIOD ={'$(vCurrentPeriod)'},
IN_BUDGET = {'Y'},
TYPE = {'ACTUAL'},GROUPING_HIGH = P(GROUPING_HIGH)>}
/1000000
I definitely sorted that, it doesn't work. thank you anyway