percentage queries

W

Willied4eva

I have 2 columns that are dollar amounts and i need to figure out the profit
percentage. can u help me.

example by dividing the profits byt the assests i would get a percentage and
that is the answer but i cannot get it to show properly.
 
M

[MVP] S.Clark

Percentages require a part and a whole as:
percent = part / whole

Therefore, you may need one query that calculates the whole, then a second
query that infuses the part, thus getting the percent.
 
Top