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

3X_e_6_e6e136730e403cfee7b35afb2b86493f108964fe.png

0 2 135
2 REPLIES 2

Define “EASY”

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

That might just work for my needs. Thanks!!

Top Labels in this Space