View source for Pos3/Pos5/FNB: How is margin percentage calculated at POS Profit Margin Report

<u><b>Question :</b></u>

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

[[File:000125-a.png|1000px]]


<u><b>Solution :</b></u>

<b>Formula is :</b> 

<span style='color:blue'>Margin = ((TotalExTax - LocalTotalCost) / A.TotalExTax)  x 100</span>

<b>Sample 1 :</b>

[[File: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%


<b>Sample 2 :</b>

[[File:000125-c.png]]


Margin = ((15- 10.07) / 15) x 100

Margin = (4.93/ 15) x 100

Margin = 0.3287 x 100

Margin = 32.87%


By: CK 20201020 , Jacky 201124, P201126 [000125]

{{NavigateForUser}}


[[Category:Users]]