Getting rid of decimal places

[iRm]

Hi,

I have a scenario where I have a field value coming in as 12345678.00. It is coming in from the database as FixedDecimal16.2. So, I changed it to FixedDecimal16.0 and now, the decimal places are gone and it is coming in as a whole number but when I use it in a table (part of a report) it is now coming in with commas! Not what I intended! I tried to change this to string but the decimal place is back again!

This seems simple enough but I am having some issues with this.

Any help is greatly appreciated!

Thanks

[AmeliaG · Accepted solution]

Hi @iRm,

After changing it to a Fixed Decimal 16.0, change the value to a string. The table tool by default displays numeric values with commas but it will not insert commas for string values. 

Hope this helps!

Amelia

[iRm]

Thank you for your solution! That worked!