help formatting numbers

[martinqlik]

Hello, Qlikers!

I have values in my project that eventually comes into different format from database. I can't use same format pattern for all of them because that problem. I have an example below:

DB               How I need to format

35545875  =         35.545

31294345  =         31.294

44100.7     =         44.100

43250.7     =         43.250

1328         =          1.328

12.9          =           12.9

Does anyone have faced something like that?

Tks,

[YoussefBelloum]

Hi,

maybe try this on the script:

Num(FIELD, '#,##0', '.' , ',' ) as FIELD

[YoussefBelloum]

Or this:

Num(FIELD, '#.##0', ',' , '.' ) as FIELD