Skip to main content
Question

Formula fields not calculating

  • January 28, 2020
  • 0 replies
  • 83 views
Hey,

I've working on a formula rich text field which displays some warning text depending on if certain fields are null.

when i have this field in a form, all my other calculations seem to fail (including this one) unless all conditions are true. Rather each calculated field without a True value is left with a ??? value.

Anyone know how to fix? QB support doesnt seem to know how.

------------------------------
GMacri
------------------------------
GMacri

  • BrandonDrake
  • Registered
  • January 28, 2020

Hello GMacri,

It is hard to tell with the information provided, it may be easier to help you troubleshoot if we had more a description of what the formulas are doing and perhaps a copy of the formula, if possible, and the resulting error/values.  However, if they are numeric calculations, a common problem would be that the check box "Treat blank values as "0" in calculations" in the field properties not being checked would cause calculations to fail.  Beyond that, it is hard to say without more information.



------------------------------
Brandon Drake
JHI Group
Monroeville OH
------------------------------
Terms & ConditionsAccessibility statement