# Discussions

View Only

## Checkbox Formula - Greater than

• #### 1.  Checkbox Formula - Greater than

Posted 06-01-2015 16:16

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

• #### 2.  RE: Checkbox Formula - Greater than

Top
Contributor
Posted 06-01-2015 16:19
try this

IF([Tier Stage] = "Active" and [Weight] > 24, true)

• #### 3.  RE: Checkbox Formula - Greater than

Top
Contributor
Posted 06-01-2015 16:21
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)

• #### 4.  RE: Checkbox Formula - Greater than

Posted 06-02-2015 19:04
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?

• #### 5.  RE: Checkbox Formula - Greater than

Top
Contributor
Posted 06-02-2015 19:22
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?

• #### 6.  RE: Checkbox Formula - Greater than

Posted 06-02-2015 21:13
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.

• #### 7.  RE: Checkbox Formula - Greater than

Top
Contributor
Posted 06-02-2015 21:24
:)

• #### 8.  RE: Checkbox Formula - Greater than

Posted 05-03-2017 19:36
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.