I have looked at the other topics yet I cannot find the solution.
I am simply trying to add two values from an excel file.
The values are of the type “1000” or “1000.5” if there are decimals. The problem is when using “Get row item” it stores the output as STRING type generic variable (eg. “debits”) in the case of “1000” and DOUBLE type generic variable (eg. credits) in the case of “1000.5”, when I try to add/subtract these two variables eg. balance = debits - credits, I get an error : you cannot subtract a system double from a system string
When I try to convert to double first using double.parse(debits.tostring) I once again receive an error:
input string was not in correct format (refer attached)