Skip to main content
Question

Checkbox Formula - Greater than

  • June 1, 2015
  • 0 replies
  • 26 views

I need to write the following formula for a checkbox field;

If [Tier Stage] = "Active" and [Weight] > 24, true.

The formulat I have in now returns no errors, but the boxes are not showing checked when criteria is true.

[Tier Stage] is a Text Field, [Weight] is numeric

This topic has been closed for replies.

try this

IF([Tier Stage] = "Active" and [Weight] > 24, true)
be sure about your "fence posts" -  you might actually want to be true on Greater Than or Equal to 24.

IF([Tier Stage] = "Active" and [Weight] >= 24, true)
  • NikkiWalters
  • Author
  • Registered
  • June 2, 2015
I have tried both formulas.  The field does not contain an error when saving, but no boxes are showing checked in the records that qualify.  Any ideas why?
On a record that is not checked, what value is on the field [Tier Stage] and it it possible it has a trailing or leading space in it.  What value is in  the field for weight?
  • NikkiWalters
  • Author
  • Registered
  • June 3, 2015
Thank you for making me think.  The value in the Weight field is a percent.  I changed from 24 to .2 and it's working great.   Thank you for your assistance.
:)
  • JohnParham
  • Registered
  • May 3, 2017
This is great I had a similar problem and didn't realize I needed to change my formula to .xx.  Makes sense if the field is a percentage. 
Terms & ConditionsAccessibility statement