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