9 Replies Latest reply: Jan 10, 2017 11:46 AM by Rob Wunderlich RSS

    Problem calculating margin

    Kristoffer Berner

      Hi all,

       

      I want to calculate the margin for a product sold (all products really) but I don't really get how I go about it.

       

      From what I've gathered I should do a calculation similar to this:

       

      (SalesPrice * Amount) * (1-rebate) - (SalesCost * Amount)

       

      but where do i do this? all of the listed stuff is in one table (table A) except for SalesCost which is in another table (Table B)

       

      All and any thoughts are appreciated.

       

      Thanks