Forum Discussion

JimHarrison's avatar
JimHarrison
Qrew Champion
5 years ago

Form Rules: Difference between "Does not Equal zero" vs "Is Greater than zero"

Curious to know if the logic here is the same or different? Reason I mention it, is sometimes I can set a form rule to "if field does not equal zero then show some field (implied otherwise hide fie...
Forms
Tables and fields
AhuvaBrown's avatar
AhuvaBrown
Qrew Cadet
5 years ago
I've come across this issue as well. On numeric fields, there's an option to check off a box to "Treat blank values as "0" in calculations". If that box is not checked off and the field is blank, it will register as a null value rather than 0

------------------------------
A Brown
------------------------------
  • AustinK's avatar
    AustinK
    Qrew Commander
    5 years ago
    Seconding this. We have just started to check all of our numeric fields in our app to see which are set to this and which are not. Keeping this consistent through all the fields makes formulas easier for them since you don't have to check and see what the field is set to. If it is set to treat blanks as 0 and you do a formula to check it for null, the formula will not error. It just won't work.