-
percentage in a query
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 ?
-
Is your Field Property for your calculated field set to Percent?
-
Yes, i see my error ! thank you very much !
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules