Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone, I am in the middle of an important project, and I am very exhausted, so maybe this question will be very easy to answer:
I am calculating engagement margin percentage and I need help with calculation. I want to show 0s or Nulls when both Net Revenue and Eng. Margin are negative numbers.
Formula is sum(NetRevenue)/sum(Eng.Margin)
Thanks in advance
Hi,
Try with
=if(Sum(NetRevenue) and Sum(Eng.Margin)<0,'',Sum(NetRevenue)/Sum(Eng.Margin))
Hi,
Try with
=if(Sum(NetRevenue) and Sum(Eng.Margin)<0,'',Sum(NetRevenue)/Sum(Eng.Margin))
thanks a lot