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 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
------------------------------
  • 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
      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.