A way Trim decimal places when not needed?

AppSheet AppSheet Q&A
1

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
3X_e_6_e6e136730e403cfee7b35afb2b86493f108964fe.png404×196 11.2 KB

2

Define “EASY”

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

3 Likes
3

Marc_Dillon:

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

That might just work for my needs. Thanks!!

3 Likes