AnsweredAssumed Answered

Calculating Margin with Neg Revenues

Question asked by user28271 on Sep 14, 2017
Latest reply on Sep 15, 2017 by DavidJondreau

Well it took 22 years but I finally encountered a Job P/L with a negative Revenue which rendered my margin calculation useless.

 

I hack through the math, but does anyone have a custom function for this?

 

Screen Shot 2017-09-14 at 7.34.54 PM.png

 

 

Screen Shot 2017-09-14 at 7.38.28 PM.png

 

I found this but it return the same 212%

 

Screen Shot 2017-09-14 at 7.39.27 PM.png

Outcomes