Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try this expression
Sum({<Totais = {'$(vTotalDisc)','N/A'}>}Revenue) / Sum({<Totais = {'$(vTotalDisc)','N/A'}>}TOTAL Volume)
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.
@asantos try to exclude selection of DescontoSimples
Sum({<Totais = {'$(vTotalDisc)','N/A'}>}Revenue) / Sum({<DescontoSimples,Totais = {'$(vTotalDisc)','N/A'}>}Volume)
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?