Veröffentlicht Tue, 03 Sep 2024 18:12:03 GMT von 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!
Veröffentlicht Tue, 03 Sep 2024 18:38:09 GMT von Saturnino Ayala Ricoh Senior Solutions Integrator
Try testing like this:
IsNumeric(DW_ VARIABLE)
0 = false 1 = true
 

Sie müssen angemeldet sein um Beiträge in den Foren zu erstellen.