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

    Problem calculating margin

      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.