Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team
Need Help in getting a result.
PFA image.
I have a requirement where I need to display net price. I have written below expression s:
= Max(Aggr(Sum(If( [Net Sales] > 0 AND [Net Volume] > 0, [Net Sales] /[Net Volume] )), Region, Destination))
for considering +values .
= Max(Aggr(Sum(If( [Net Sales] < 0 AND [Net Volume] < 0, [Net Sales] /[Net Volume] )), Region, Destination))
for considering - values.
I want only one expression for both the cases.
Please suggest
Thanks In Advance
Hi,
PFA. Is that you looking for?
-Jai
The answer Sunny gave you on the previous thread you posted on this topic will precisely what you need,