More robust ROUND() expression

As it is currently configured, AppSheet expressions can be pieced together to perform virtually any rounding operation you might desire. It’s not always easy, however. I think the following kind of ROUND() expression would simplify many rounding tasks:

2X_c_c02d64e1c0a174df4598fae689dde984e75d53b3.png

This screenshot was taken from a page about Google sheets’ ROUND() function. AppSheet has ROUND() but does not have the capability to determine where the rounding should occur.

I’ve written a bit about this here:

This is in response to @Steve’s very useful tip about integers vs. decimals in AppSheet.

By the way, here’s an example of a strategy for rounding in AppSheet that would continue to be necessary, even if the ROUND() expression were made more powerful:

Status Open
3 1 700