Hello,
my table runs a query on mySQL which provides a numeric field.
Since I'm in Italy, I should show the numbers using "." a thousand separator and "," for decimals (4 decimals).

For example:
- 123.4 shown be shown as 123,4000
- 4 should be shown as 4,0000
- 1234.56 should be shown as 1.234,5600
- 12345678,9 shoud be shown as 12.345.678,9000

I tried some tests in Options -> Column Settings -> Format but the best thing I did was "{$value|number_format:4}" which just show 4 decimals, however it does NOT put the right decimal separator (,) and does NOT Group the thousands together.

Thank you

Mauro

Hello,

Use the following value for "Columns settings -> Format" parameter:

{$value|number_format:4:,:.}

Regards,
ARI Soft

simply perfect. As Always. Thank you