If you have questions or if you want to share your opinion about Aware IM post your message on this forum
#54030 by eagles9999
Fri Jun 05, 2020 10:36 am
I have an app which requires changing Culture so that numerical values display as #.###,0 rather than #,###.0
I have changed the Culture in the Locale and everywhere in the app it works.... well, nearly everywhere.

I cannot get a Report to display the numerical values in the right format. I have tried casting the values with @'#.###,0' and also tried AS_STRING(Number,'#.###,0')

No joy.

Has anyone come across this and found a solution please?
#54035 by eagles9999
Fri Jun 05, 2020 2:44 pm
That syntax is not accepted. Syntax error

<<Object.Number,'#.###,0'>> is not accepted - syntax error
<<[email protected]#.###,0>> is accepted but displays nothing
<<[email protected]'#.###,0'>>is accepted but displays nothing
#54036 by Jaymer
Fri Jun 05, 2020 7:00 pm
Screen Shot 2020-06-05 at 2.59.29 PM.png
Screen Shot 2020-06-05 at 2.59.29 PM.png (51.52 KiB) Viewed 440 times


from inside the report writer, both of these work
#54037 by eagles9999
Fri Jun 05, 2020 7:10 pm
Try swapping the . and the , Jaymer.
#54038 by tford
Sat Jun 06, 2020 12:02 pm
It sure sounds like there is no easy formula solution to this, Mark. Looks like Aware is confused by the , and seeing it as a delimiter.

I know it would be clunky, but as a work around could you store the formatted value in a text field and display it that way. If it's an attribute or two, it seems that might work. If it's a bunch of attributes, I'm sure that would be a pain.

Who is online

Users browsing this forum: No registered users and 20 guests