If Failure

[christian1 (Chris)]

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 !

[Nithinkrishna]

Hey @christian1

Try using CDbl(string)

Thanks
#nK

[Lak_Ui (Lakshmi)]

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

[mosa_sleeman (Mousa Suleiman)]

use CDbl to convert your value