cancel
Showing results for 
Search instead for 
Did you mean: 

How to calculate Total Gross Profit % in SAP

mat_mat
Active Participant
0 Kudos

Hi,

I'm concern about how does B1 calculate the total of gross profit %, what is the formula that system use?

Example: I have two items in my sales order, and the gross profit is set to (Profit / Base Price),

Item A :

Base Price = 8.62

Sales Price = 15.60

Qty = 2

Gross Profit = (Sales Price - Base Price) * Qty = (15.60 - 8.62) * 2 = 13.96

Profit % = Gross Profit / Base Price / Qty = (13.96 / 8.62 /2) * 100 = 80.97

Item B:

Base Price = 3.25

Sales Price = 16.25

Qty = 2

Gross Profit = (16.25 - 3.25) * 2 = 26.00

Profit % = (26.00 / 3.25 / 2 ) * 100 = 400.00

Total Profit % for this two items = 168.32

The above calculation I can understand. But how does system calculate the Total Profit % = 168.32

Any one know the formula for Total Profit % ?

Thanks in advance for any help.

Regards,

Muhamad

View Entire Topic
Former Member
0 Kudos

hi mat mat,

so you have kept your gross profit according to your base price.calculate the total profit and calculate the total base price.then do total gross profit/total base price * 100 will give you the gross profit for the document....

in brief according to your scenario......

total gross profit for itemA and itemB = (15.60-8.62)2+(16.25-3.25)2

= 13.96+26 = 39.96

total base price for itemA and itemB = (8.622)+(3.252)=17.24+6.5=23.74

finally total gross profit/total base price = (39.96/23.74)*100 = 168.32

hope this will give you a clear picture

regards

Ravindran srinivasan