Decimal Places - Always Show Two Decimal Places

[mykrobinson]

How do I get AppSheet to always show two decimal places? For example, if a value is 0.6, i want AppSheet to display 0.60 instead of 0.6

[SkrOYC]

By configuring the "Decimal digits" under the "Decimal" column config

[mykrobinson]

that's what i would have thought. Let me go back and confirm that I actually used 2 in all places for this particular use case.

[mykrobinson]

@SkrOYC i have found the problem but need to figure out how to fix it 🙂

The decimal places are properly showing, however, i have a TEXT field that concatenates some values and displays them. THe concatenation is truncating the decimal place.

CONCATENATE([Lower Limit]," - ", [Upper Limit])

This takes [Lower Limit], which is a decimal with two places, adds " - ", then takes [Upper Limit], which is also a decimal, and displays them like this:

so how do I get the concatenation to pull in the exact value without altering it?

Thanks

[Marc_Dillon · Accepted solution]

Use TEXT() I think, to convert the numbers to text before concatenating.

[Steve]

TEXT() - AppSheet Help

[mykrobinson]

Thanks, folks. This seems to work as expected:

CONCATENATE(TEXT([Lower Limit])," - ", TEXT([Upper Limit]))

The only negative is that old records must be re-saved to get the desired display, but there's not a lot of records for this table yet, so we're in good shape.

[SkrOYC]

You may want to implement a "quick update" method, I think @MultiTech has a post about it.

Basically you can have an extra column that's updated via action and it triggers an update to your formulas