Discussions

Expand all | Collapse all

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

    Posted 06-01-2015 16:19
    try this

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


  • 3.  RE: Checkbox Formula - Greater than

    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

    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

    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.