How to ignore filter selections in this formula?

[Ken_Hardwick]

Hello,

How do I ignore filter selections in this formula?

sum(Aggr($(vWrite_off_total),StockCode))

Thanks

[rubenmarin · Accepted solution]

Hi, you can use: sum({1}Aggr($(vWrite_off_total),StockCode)).

Additional {1} should be set on each function of the expression contained in vWrite_off_total

[Ken_Hardwick]

Thanks @rubenmarin. 

I did use the {1} in the main formula before posting this question but it is the additional requirements in the variable that is obviously causing the issue then. I did not think of that.

The variable vWrite_off_total contains more variables so a difficult change to make and I have not attempted the solution yet. But at least I know where the issue is.

Thanks for the solution.