FormatNumber is not working in Production System.

[Former Member]

Hello Everyone,

I have very strange problem of FormatNumber.

I am using ###,###,##0.00 with decimal separator as comma "," in the properties which gives me a correct result in DEV & PRD as 12.345.678,00 but when I transported the same solution to PRD system it just gives the opposit result like 12,345,678.00

I have update the cache both sxi_cache & CPA.

Can you please give me some solution for this problem.

Any help will be appriciated.

Regards,

Sarvesh

[Former Member · Accepted solution]

Hi,

please try some other convention like % or somethng

even *0.00 should work

Rgds

Aditya

[Former Member · Accepted solution]

Hi,

I have tried with your solution it works in DEV & QA but as soon as I imported it into PRD it doesn't work there as per the expectation.

Can anyone help me in writing the UDF for the same.

Regrds,

Sarvesh

[Former Member · Accepted solution]

If there is no way just believe in yourself.

I just created the UDF after lots of calculation to make it dynamic and solved the problem.

Thanks for your help & suggestions.

Regards,

Sarvesh