Question :
When I view POS Profit Margin Report, there is a Margin (%) column. What is the formula to calculate the margin?
Solution :
Formula is :
Margin = ((TotalExTax - LocalTotalCost) / A.TotalExTax) x 100
Sample 1 :
Margin = ((-0.11- -4.23) / -0.11) x 100
Margin = (4.12/ -0.11) x 100
Margin = -37.4545 x 100
Margin = -3745.45%
Sample 2 :
Margin = ((15- 10.07) / 15) x 100
Margin = (4.93/ 15) x 100
Margin = 0.3287 x 100
Margin = 32.87%
--Source from AutoCount Wiki --