Hi All....
Here is a bit of a mystery....
I have an app that we are developing for the European region and hence all Number attributes are displayed
as #.###,00. ie. Thousands separator is a '.' and the decimal point is a ','
When just using Numbers, everything is fine. All display perfectly.
However, we have a place where we need to take a Number Attribute and then convert it to a string using AS_STRING and
then display the result as a String with the correct format.
Logically, I would have expected to be able to convert it as follows....
MyBO.MyNumberString = AS_STRING(MyBO.MyEuropeanNumber,'#.###,00')
However, that throws a java format error.
But ,
MyBO.MyNumberString = AS_STRING(MyBO.MyEuropeanNumber,'#,###.00') while it does not throw an error.... produces the incorrect resultant string.
Does anyone know a way around this problem please?