If Failure

Hello together,

I have one open question - I receive the following error message in studio X

I have the following situation - I read a value from SAP with get text and save it to a variable called saldo.
then I have an if

Saved.Values(Of ExcelValue)(“saldo”) > string.Format(“3.999,99-”) AND Saved.Values(Of ExcelValue)(“saldo”) < string.Format(“2.000,00-”)

is it possible to change this string values to number values, so that it is possible to compare that range

this if should also be extended but by now I am still working on this failure

Thank you !

Hey @christian1

Try using CDbl(string)


use CDbl((“3.999,99-”).replace(”,“,”').Replace(“-”,“”)

use CDbl to convert your value