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:

Screen Shot 2020-02-25 at 18.27.47

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: