I used invoke code activity like this in below screenshot:
So when I gave an actual number in StringVar1 like “1.2”, the boolean output SuccessOrNot is true and the double value is available in the variable “DoubleNumber”
Similarly when I gave StringVar1 like “one”, the boolean output SuccessOrNot is false and therefore we shouldn’t consider output DoubleNumber in this case.
If you use same kind of code, pass CurrentRow(“YourColumnName”) instead of StringVar1. As you have SuccessOrNot boolean variable, use if condition to check the conversion is successful or not. Based on that you can make use of the result and move on to the next row.
Hope this helps you. Let me know if you are still facing any challenges at any step