Culture in Report - Number Formats

customaware

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?

ACDC

In the report writer, have you tried <<Object.Number,#.###,0>>

customaware

That syntax is not accepted. Syntax error

<<Object.Number,'#.###,0'>> is not accepted - syntax error
<<Object.Number@#.###,0>> is accepted but displays nothing
<<Object.Number@'#.###,0'>>is accepted but displays nothing

Jaymer

Screen Shot 2020-06-05 at 2.59.29 PM.png

from inside the report writer, both of these work

customaware

Try swapping the . and the , Jaymer.

tford

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.

aware_support

This is a limitation that will be removed in the next version.