How to Check If a Numeric Value in a Collection Is Empty (Null) in Blue Prism?

[Omar-Abu-Snineh]

Hello,

I understand that Blue Prism does not explicitly support null values. However, I have a collection with a numeric column named Sum, and all records in this column appear to be empty.

My goal is to verify whether the data was actually received or if the values are just empty. I initially thought of using a condition like [Collection.Sum] = Null, but since null is not explicitly supported, I'm unsure how to properly check this.

I also tried using [Collection.Sum] & "" = "" to check for empty values, but I keep encountering the following error:
"Invalid or blank value supplied for Collection.Sum"

What is the best way to confirm that a numeric value in a collection is truly empty? Any guidance would be appreciated!

Thanks in advance!

[Nandhakumar]

Hi @Omar-Abu-Snineh ,

Its better to catch the exception being thrown when you check IsNumber(). because when the value is invalid or blank for the field then you will get the same error message everytime(Invalid or blank value supplied for Collection.Sum). 

so when there is no / invalid data, we get exception and we catch it and proceed with next steps accrodingly.

Thanks,

Nandha