# FOUT or #ERREUR error while using Tonumber function.

[Former Member]

Hi Experts,

We are facing issue with ToNumber function in WebI. Report is created in english language and working perfectly fine without any error. However when users are using local language (e.g. french or dutch) then results are ending with error. #FOUT error faced by french users while #ERREUR error faced by dutch users. Source of report is BEx query using BICS connectivity without universe. Any prompt response highly appreciated.

[Former Member]

Numbers are often presented in a different format in different European countries.

You'll need to tweak your ToNumber to reflect the values in the string. The Wikipedia entry is quite comprehensive on this:

http://en.wikipedia.org/wiki/Decimal_mark

Regards,

Mark

[Former Member]

Hi Mark,

We can not change with the source data however as far as I know, To number is local function and does`t work for other locals. Is there any other function or change in syntax can be carried out. Right now  we are using as ToNumber(dimension attribute). Attribute data type is number only.

[Former Member]

Create another object in the universe, casting/converting the character to number there, stripping off the dollar sign, etc.

However, be careful - are there decimal places involved?