Summary vs. Sum

[yankeer0se]

I have a budget calculation field that calculates: price * quantity * percent.

I created a summary field to calculate the total budget for a given item (this number is correct.) I have also tried to create another field that is Sum (Budget).

These 2 fields, that are basically doing the same calculation (or so i think) are coming up with different results. The Summary is correct. The Sum result is coming up with some funky numbers!

I am trying to make another calculation which takes total budget (number from summary field or Sum) minus budget spent.

I have no idea why the 2 are getting different results. Any insight would be greatly appreciated.

Thanks.

PS these values are sorted by global dates, by vendor and by location.

[mr_vodka]

A summary field will sum up the referenced field across the found set. A calc field using sum will not work across a found set. It does work on related records though. For example, if you had a calc field in the parent invoice table that sums up the related child line item amounts...

[yankeer0se]

Thank you very much. That makes sense.