Appearance of INT in a data table

0

Hi Joanna,
From Advanced configuration there is no option that would change the formatting of the field.

You could achieve it with querying database using SQL with FORMAT and REPLACE functions:

SELECT REPLACE(FORMAT(123321123321.22, 'N2', 'de-DE'), '.', ' ') AS Test -- Space separated
SELECT FORMAT(123321123321.22, 'N2', 'en-US') AS Test -- Comma separated
SELECT FORMAT(123321123321.22, 'N2', 'de-DE') AS Test -- Dot separated
SELECT 123321123321.22 AS Test -- No separation


This although will be rendered with align to left most certainly - as webcon will treat it as text.

Also, are you sure that we are talking about integers?
Integer numbers don't have fractional part, so i assumed, that we are talking about decimals ;)

"Integer numbers don't have fractional part, so i assumed, that we are talking about decimals ;)" Yes of course, I wrote wrong..

Anyway, thank you very much, that helped :)