Calculating correct percentage

[zufie]

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([MinOfAgencyCont actYes])))/
(Abs(Sum([MinOfAgencyCont actYes])))+
(Abs(Sum([MinOfAgencyCont actNo])))))

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

[zufie]

Re: Calculating correct percentage

On Sep 18, 3:03 pm, zufie <john.marru...@ illinois.govwro te:

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([MinOfAgencyCont actYes])))/
(Abs(Sum([MinOfAgencyCont actYes])))+
(Abs(Sum([MinOfAgencyCont actNo])))))
>
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([MinOfAgencyCont actYes])))/
(Abs(Sum([MinOfAgencyCont actYes])))+
(Abs(Sum([MinOfAgencyCont actNo])))))/10

Thanks!!!!!!!!

John