Number Formatting

[gabriele_qlik]

Hi,

is there a number format that it shows decimals when there are decimals and it not shows decimals when there aren't decimals?

For example, if I have 2000 I want to show 2.000 and not 2.000,00 but if I have 2000,55 I want to show 2.000,55 and not 2.000.

Thank you

Gabriele

[marcus_sommer]

Try it with something like: num(VALUE, '#.##0,##')

- Marcus

[gabriele_qlik]

I try it but it doesn't work 😞

Thank You

Gabriele