A2.116 : How is margin percentage calculated at POS Profit Margin Report

A2.116 : How is margin percentage calculated at POS Profit Margin Report

Question :

When I view POS Profit Margin Report, there is a Margin (%) column. What is the formula to calculate the margin?

000125-a.png


Solution :

Formula is :

Margin = ((TotalExTax - LocalTotalCost) / A.TotalExTax) x 100

Sample 1 :

000125-b.png


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 :

000125-c.png


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 --