4 Replies Latest reply: Sep 13, 2012 5:32 PM by Michael Ellerbeck RSS

    Help with Margin % expression, problem with division by zero?

    Michael Ellerbeck

      I have two rows of data, Customer, Product, Cost & inputfields of New Price and New Volume

       

      The Bid Sales is calculated by New Price * New Volume

       

      The Bid Cost is Cost/LB * New Volume

       

      The Margin $ Is Bid Sales - Bid Cost

       

      And the Margin % is Margin $ / Bid Sales

       

      This appears to work but when I put in values for the first product for the first New Price and New Volume the total for the Margin % shows 10% when I would expect it to be 50%, matching the single row of data's margin.

       

      margin.PNG