Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a report with dimensions representing products and expressions that sum Sales/Cost/GM%. How can I display products with only negative margins in my report?
HI
If my understanding is correct,are you expecting to display only negative values, if so,
try like this
=If(YourExpression < 0, YourExpression)
try a calculated dimension.
=if(Aggr(sum(Margin)<0, Product), Product, 'Null')
or see the attached file