Skip to main content
Question

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

  • February 20, 2021
  • 0 replies
  • 218 views

JimHarrison
Forum|alt.badge.img+16
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 field)" - based on a summary for instance - and it works. Then a month or so later, it stops working. So I go in and change it to "if a field is greater than zero show some field (implied otherwise hide field)" and it works.

Condition 1 is true if it does not equal zero.
Condition 2 is true if it is greater than zero.
Both conditions evaluate as true if value is not zero.
Both conditions evaluate as false if the value is zero.

Why's it do that?




------------------------------
Jim Harrison
transparency = knowledge + understanding : The Scrum Dudes
------------------------------

  • Quickbase Alumni
  • February 21, 2021
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
------------------------------