4 Replies Latest reply on Jun 27, 2018 7:23 AM by Shinichiro Murakami

    Is there a way to subtract one subtotal from another?

    Michael Stein

      See attached picture for an example of my table layout.  The Volume and Total Price are not signed.  I'm trying to calculate something like a Net Margin and display this at the bottom.  Is there a way I can can take the SELL Subtotal and subtract it from the BUY Subtotal (in the Volume and Total Price columns)?  If I add the Grand Total, I get 20,000.00 for Volume and $58,650.00 for Total Price because the values are not signed.  In this case, I want the Net Margin to be zero.  I'm not sure how to do this since the values are all positive.