Conditional Calculation

[Milutin]

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

[sergio0592 · Accepted solution]

Hi,

Try with

=if(Sum(NetRevenue) and Sum(Eng.Margin)<0,'',Sum(NetRevenue)/Sum(Eng.Margin))

[Milutin]

thanks a lot