yankeer0se Posted September 17, 2012 Posted September 17, 2012 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 Posted September 17, 2012 Posted September 17, 2012 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... 1
yankeer0se Posted September 17, 2012 Author Posted September 17, 2012 Thank you very much. That makes sense.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now