How to ignore a dimension based filter in an expression

[asantos]

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.

[Vegar]

Try this expression

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

[asantos]

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.

[Kushal_Chawda]

@asantos  try to exclude selection of DescontoSimples

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

[Vegar]

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?