Totals are not adding

[Czeszyn]

Not sure what I am doing wrong. I have two columns in my report that at the bottom it gives me the following total, as I put below. I am trying to take the two totals that is gives and get the percentage. 1058/3024 = 35%.

=Sum([TotScrwBlank]) =Sum([TotalAmount]) .349 or 35%
1058 3024

I had did the equation as =Sum([TotScrwBlank])/([TotalAMount]), but this is giving me the answer of 46% which is not correct.

Not sure what I am doing wrong. I hope that this is a easy fix.

Thank you in advance.

Tony :banghead::banghead:

 

[plog]

You are summing the quotients, you need to get the quotient of the sums:

Sum([TotScrwBlank])/Sum([TotalAMount])

 

[Czeszyn]

I put that in, and I get this message:

Syntax error in query express 'First([Sum([TotScrwBlank])/Sum([TotalAmount])])'
not sure why,

 

[Czeszyn]

Got to work. Thank you very much.