Support Topics Documentation Slack YouTube Blog

Format decimals in generated column in data table

Hello,

I try to get a value in the data table with 2 decimal places, but when i use the FORMAT function in a generated column it shows either one, two or no decimals. How can i get it to always show two decimals?

image

When i specify the locale the generated expression does not work.

Hello @Michel_Loriaux

Change type of generated column from DUUBL to STRING
But keep in mind that the format for large numbers will be like this: 243453 → 243,453.00

Regards,
Viktor

Hi Viktor,

That does work, however i cannot sum those values, is there another way to set the numbers to the locale format?

Another issue is when i use FORMAT(value,2) as DOUBLE i cannot get any value higher than 1000 in a generated column. Any idea how to solve this?

Data service tab isn’t intended for the end user, it is just the storage.
It is designed to help developers with the creation/configuring/debugging and a simple correction of data records and it doesn’t fit for presentation.

For you goal I can advise the UI builder. It was created for building user interfaces where you able format and show data in any form and show it to the end consumer.