Calculating correct percentage

**zufie** · Sep 18 '08, 08:05 PM

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