topic How to ignore filter selections in this formula? in App Development

How to ignore filter selections in this formula?

Ken_Hardwick — Wed, 07 Jul 2021 08:20:10 GMT

Hello,

How do I ignore filter selections in this formula?

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

Thanks

Re: How to ignore filter selections in this formula?

rubenmarin — Wed, 07 Jul 2021 08:43:34 GMT

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

Re: How to ignore filter selections in this formula?

Ken_Hardwick — Wed, 07 Jul 2021 15:55:06 GMT

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.