Decimal in Straight Tables

[ShaBeeN]

Hi All,

I have a straight table with the following values. I want to assign decimal values so it'll be much easier to read.

For example, first row should be 3,518,250 and 148,877,412.29

Is this possible in Straight Tables?

I used =num(income_multiplier,'0,00') but for values less 1,000, incorrect data is getting populated. If the original value is 346.9, after the conversion, it's shown as 0,347

[abhijitnalekar]

Hi @ShaBeeN,

Try number formating from property panel.

[ShaBeeN]

It's not available

[abhijitnalekar]

Hi @ShaBeeN ,

In that case, your field's data type must be not a number?

Please change your field datatype to number then you can see the property.

You can change the datatype like this Num#(fieldsname) as fieldname

[ShaBeeN]

I used =num(income_multiplier,'0,00') but for values less 1,000, incorrect data is getting populated. If the original value is 346.9, after the conversion, it's shown as 0,347

[abhijitnalekar · Accepted solution]

Hi @ShaBeeN ,

Please try

num(income_multiplier,'#,##0')

[ShaBeeN]

Thank you so much. It worked