Part of set analysis fixed and part change with variables?

[MZambo89]

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

[Digvijay_Singh]

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

[MZambo89]

No unfortunately this doesn't solve it...

[Digvijay_Singh]

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

[MZambo89]

I definitely sorted that, it doesn't work. thank you anyway