Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
How do I ignore filter selections in this formula?
sum(Aggr($(vWrite_off_total),StockCode))
Thanks
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
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
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.