Posted Tue, 03 Sep 2024 18:12:03 GMT by Daryl Foxhoven
I have a customer using a Workflow where we're looking to see if an index field is blank or not.  The issue is, the field is a decimal...and techincially....0.00 is a valid value, however, my condition is treating 0.00 and blank index fields the same.  I've tried rate>=0, rate=null, rate=nothing, rate=0 and all treat a blank index field and a value of 0.00 the same.  Anyone know how to accomplish this....I've even tried 2 separate conditions with no success.

Thanks!
Posted Tue, 03 Sep 2024 18:38:09 GMT by Saturnino Ayala Ricoh Senior Solutions Integrator
Try testing like this:
IsNumeric(DW_ VARIABLE)
0 = false 1 = true
 

You must be signed in to post in this forum.