How to check the value exists in data item which is of number data type?

[DilipK]

Hi , Question :How to check if the  value exists in data item (number data type) or not? Please note:- 1)[Data item ] "" - is working incase if the data item is of text data type. 2) when the data item is number data type it throwing an internal exception "cannot perform when the left hand value is empty" Internal : Cannot perform operation when the left-hand value is empty   Any suggestion? Regards, Dilip K  

[david.l.morris]

Hi, In my opinion, best practice is to initialize all your number data items (e.g.- zero) and then check that [Number item]>0. Would that work for your situation? Respectfully, Dave

[IrynaMilyanenka]

There is an in-built logic function IsNumber() in Blue Prism. It returns true if the input is a number.

[david.l.morris]

Hahahahaha! Good point, Irina! I'm *facepalming* over here. Can't believe I forgot about the Is functions.