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
Solved! Go to 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
Thank you for your solution! That worked!