help with calculation in report 1

[Spyridon]

Anyone care to straighten this out?

I have 3 text boxes in a report that are:

"Orders" "Canceled" "Finished" "Percent Finished"
124 26 98 ?????

I'm needing to find the percent of finished orders. The calculation is a mess, but the only problem comes in with the "Percent Finished". What I have in there right now is:

=(Abs(Sum([Status]="Finished&quot)/Abs(Sum([Status]="Finished&quot)+Abs(Sum([Status]="Canceled&quot))

but this gives me a total of %2700... which is obviously not right. It should be around %79.. Anyone care to help???? Please, Please, Please!!

 

[cghoga]

try this...

In your text box control source enter:

=[Finished]/[Orders]

Next, in the Format property of same text box select Percent.

Run it.

Does this work?

Hope this helps you.

 

[Spyridon]

oh my goodness... and I thought that I had already tried that and it wouldn't work. Shame on me... And may band of generous leperchauns come your way!

Thanks!