Expression calculating incorrectly?

[nicks60610]

For some reason this expression I have in my query calculates the wrong values for every other row? The calculation I have is as follows:

Cycle Count: ([Std Pk Qty])*([Qty])/([CAV])

So for example:

Row1:

Std Pk Qty = 1
Qty = 1080
Cav = 4

hence, Cycle Count = 270

On Row 2 however, I have this

Std Pk Qty = 48
Qty = 106
Cav = 4

and I get this for Cycle count = 3816?? When I run the same calculation on a calculator I see, 1272???

What am I missing here and why only every other row?

Thanks!

 

[lespaul]

what's the entire SQL query? (switch to SQL view instead of Query Grid view)



Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design

 

[nicks60610]

I figured it out! I removed the Sum() before the expression and then it was calculating properly...how weird?