A way Trim decimal places when not needed?

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

Screen Shot 2021-01-20 at 2.52.37 PM

Define “EASY” :grin:

SUBSTITUTE( [decimal] , “.00” , “” ) ???

3 Likes

That might just work for my needs. Thanks!!

3 Likes