topic Re: How to ignore a dimension based filter in an expression in App Development

How to ignore a dimension based filter in an expression

asantos — Mon, 20 Dec 2021 21:08:46 GMT

Hi,

Currently, I got an expression where I try to get the Unit Price, by Sum({<Totais = {'$(vTotalDisc)','N/A'}>}Revenue) / Sum({<Totais = {'$(vTotalDisc)','N/A'}>}Volume). This would give me an additional column with null values.

I've tried escaping the "filter" set through a button, stating DescontoSimples, OtherDiscounts, etc, but since DescontoSimples is selected, it doesn't allow Unit Price to consider Volume, whose first column's data is N/A

Below is a visual simulation of the problem.

Appreciate your time put into trying to get this one right.

Re: How to ignore a dimension based filter in an expression

Vegar — Wed, 30 Sep 2020 19:50:46 GMT

Try this expression

Sum({<Totais = {'$(vTotalDisc)','N/A'}>}Revenue) / Sum({<Totais = {'$(vTotalDisc)','N/A'}>}TOTAL Volume)

Re: How to ignore a dimension based filter in an expression

asantos — Wed, 30 Sep 2020 19:57:13 GMT

Thanks for responding, @Vegar !

It then gives me a Price much lower than it should and I guess it's because it considers everything in the volume field.

Re: How to ignore a dimension based filter in an expression

Kushal_Chawda — Wed, 30 Sep 2020 20:59:34 GMT

@asantos try to exclude selection of DescontoSimples

Sum({<Totais = {'$(vTotalDisc)','N/A'}>}Revenue) / Sum({<DescontoSimples,Totais = {'$(vTotalDisc)','N/A'}>}Volume)

Re: How to ignore a dimension based filter in an expression

Vegar — Wed, 30 Sep 2020 21:41:16 GMT

Is the price lower than expected in the Totals row as well?

Maybe you could create a mockup data sample for us and a picture of your desired final output?