By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,466 Members | 1,588 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,466 IT Pros & Developers. It's quick & easy.

Add a Mark-up Percentage field to a query

P: 1
I figured out how to calculate the Profit field by subtracting the cost from the selling price. Now I need to add another field to my query that will calculate the Profit divided by the cost. I keep getting errors.
Oct 20 '17 #1

✓ answered by NeoPa

Also known as GPM (Gross Profit Margin) this is typically calculated, in a query, as :
Expand|Select|Wrap|Line Numbers
  1. GPM:Round(IIf([Cost]=0,0,([SellingPrice]-[Cost])/[Cost]),4)
Multiplication by 100 is only used when displaying the value. This is better done using the format property. Percents can be displayed, and values are automatically shown as 100 x when shown as percent.

Share this Question
Share on Google+
2 Replies


Expert 100+
P: 634
Hi

I think we need to see what you have done to calculate the net profit so we have an idea what the error may be.

Generally it would be something like
Expand|Select|Wrap|Line Numbers
  1. PctNetProfit:([Selling Price]-[Cost])/[Cost]*100
You should also check that [Cost] is not zero or null before doing the calculation.

HTH


MTB
Oct 20 '17 #2

NeoPa
Expert Mod 15k+
P: 31,186
Also known as GPM (Gross Profit Margin) this is typically calculated, in a query, as :
Expand|Select|Wrap|Line Numbers
  1. GPM:Round(IIf([Cost]=0,0,([SellingPrice]-[Cost])/[Cost]),4)
Multiplication by 100 is only used when displaying the value. This is better done using the format property. Percents can be displayed, and values are automatically shown as 100 x when shown as percent.
Oct 29 '17 #3

Post your reply

Sign in to post your reply or Sign up for a free account.