Unable to convert text to number

[MiltiadisFokas]

Hi,
I have the following error when i try to convert text to number.
When i try evaluate expression to the calculation stage i received the error when the number has the format 2.000,00 , if the number doesn't have the dot works fine( 2000,00) but the problem is that i want to add this number to the SAP and this is the format from the software and automatically SAP takes this format number.
Do you have any suggestions to solve this problem?
Thank you.

 

[gil.silva]

Hello,

The function ToNumber() will just take a 'valid number' in text format, for example and set it to Number type in BP.
The problem is that for BP dots and commas are not valid in a number.
You need to use the Replace function to remove those symbols, then you can convert it to number.

 

[hixavolev]

Try removing the , (comma)