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

Calculating correct percentage

P: n/a
I have used Sum(Abs([field])) to convert my neg. (-) values to pos.
(+) values how can I obtain the correct percentage.

For example, here is my expression from my query trying to calculate
the correct percentage, in this case, 2/2+3 = .4*100 = 40%.

Expr18: (((Abs(Sum([MinOfAgencyContactYes])))/
(Abs(Sum([MinOfAgencyContactYes])))+
(Abs(Sum([MinOfAgencyContactNo])))))

Expr18 returns 400% instead of 40% due to using Sum(Abs([field])).

How can I correct this?

I am so close to completing this report.

Thanks!,

John
Sep 18 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Sep 18, 3:03*pm, zufie <john.marru...@illinois.govwrote:
I have used Sum(Abs([field])) *to convert my neg. (-) values to pos.
(+) values how can I obtain the correct percentage.

For example, here is my expression from my query trying to calculate
the correct percentage, in this case, 2/2+3 = .4*100 = 40%.

Expr18: (((Abs(Sum([MinOfAgencyContactYes])))/
(Abs(Sum([MinOfAgencyContactYes])))+
(Abs(Sum([MinOfAgencyContactNo])))))

Expr18 returns 400% instead of 40% due to using Sum(Abs([field])).

How can I correct this?

I am so close to completing this report.

Thanks!,

John
I think I figured it out?!

Here is my new expression 18 (I divided by 10 to return the correct
percentage, in this case, 40%).

Expr18: (((Abs(Sum([MinOfAgencyContactYes])))/
(Abs(Sum([MinOfAgencyContactYes])))+
(Abs(Sum([MinOfAgencyContactNo])))))/10

Thanks!!!!!!!!

John
Sep 18 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.