5 Replies Latest reply on Oct 30, 2014 10:13 AM by KK Molugu

    how can I show -100% margin?

    Karen Massey

      I have some data in which revenue is $0, cost is a positive or negative value, and OI is likewise a positive or negative value.  The calculation of OI margin is OI/Rev, which is mathematically problematic.  However, logically it should show 100% or -100%, based on OI, since the cost reduces the margin overall.  Is there a way to include the 100% and -100% in the calculation for margin?  It seems like the aggregate margin does not correctly reflect the transactional margins.