percentage 1

[peljo]

How can i express the percent margin in a query? I have a field PurchasePrice and a field Salesprice. the field Purchaseprice is the price at which we buy the products and the field salesprice is the field at which we sell the products.I tried to substract the salesprice to the pruchase price and divide the difference with the salesprice.
Am i right and why the result in the query is not in percentage ?

 

[Remou]

Do you want mark-up or margin?

http://www.buildingtrade.org.uk/articles/markup_or_margin.html

 

[peljo]

I am very grateful for your reply and the article is so useful to me, to make the difference between the markup and the margin.On that basis will work out my query. Thank you !