I have a Decimal field defined with 2 decimal places. Most of the time the values are whole numbers. I’d like to, mainly for templates, trim the decimal places to only the significant digits. Is there any EASY trick to make that happen? Some format function or maybe a setting I am missing?
Want to remove the Decimal values in these cases
Define “EASY”
SUBSTITUTE( [decimal] , “.00” , “” ) ???
That might just work for my needs. Thanks!!
User | Count |
---|---|
44 | |
29 | |
24 | |
21 | |
13 |