the trouble is (I think) you want to do numeric comparisons but you are showing a string comparison.
it can be a bit confusing because Clarion often automatically converts strings to numbers for you.
but if you think about it, say LOC:ExcludeNonMembers had the value β8β. That is going to be greater than a string β100β because it will compare the first digit and say β8 is greater than 1β and doesnβt need to go any further.
BUT if you get rid of the quotes on β100β and do a numeric comparison
LOC:ExcludeNonMembers >= 100
you should be right to go.
BTW get rid of the useless clip()
you might want to decide what if LOC:ExcludeNonMembers has letters like βabcβ. In that case it would convert to a number zero as it is not numeric. There are tricks you can do like
if deformat(LOC:ExcludeNonMembers) >= 100
as deformat will strip out non-numeric chars.
you could also look at using Evaluate() instead - read the help and make sure you bind fields.