Calculation Error
I have a simple numeric formula field that sums 8 different fields. However, the result appears to be off by .188 (the total should add up to 11.65). I have quadruple checked the formula and related f...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendCan you post your formula? Also are the fields being summed rounded to three decimal placed or just displayed to three decimals.?
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Sure. The results aren't being rounded, just displayed to three decimals.
One thing I've found is that when I change the order in which the fields in the formula appear (principally the highlighted field), the formula result changes.
------------------------------
Kiel Berry
------------------------------
One thing I've found is that when I change the order in which the fields in the formula appear (principally the highlighted field), the formula result changes.
------------------------------
Kiel Berry
------------------------------
- MarkShnier__YouThe name of that highlighted field in your formula is not the same as the name of the field on the form.
Do you have a form override on the field name or do you in fact have two similarly named Fields and there is confusion as to which is the correct field to use in your formula.?
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- Field name overrides on the form. I've verified that the correct fields are being summed.
------------------------------
Kiel Berry
------------------------------- MarkShnier__YouOn the other thought I have is that QuickBase differentiates between fields that evaluate to 0 and Fields that evaluate to null. Perhaps that field for Resin is evaluating to null as opposed to zero. You could either change that field to ensure that blanks are being treated as null if that field is as a result of a summary field. Or if you want to go brute force you can wrap each of your addition terms in Nz to force nulls to be treated as zeros). I try to avoid that myself as it makes the formula look messy but since we are grasping at straws here for ideas, try this
Nz([field 1])+
Nz([field 2])+
Nz(field 3]) etc....
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
