I am getting an error while trying to use the...

I am getting an error while trying to use the ROUND function and specifying 2 decimal places.

When I dont give any decimal places, it is OK, but as soon as I add the decimal places argument, it says invalid inputs.

What am I missing?

0 5 710
5 REPLIES 5

We have not implemented all the โ€œadvancedโ€ excel function options. Instead, we typically start by implementing only the most common options. We then add the advanced options over time.

In the case of ROUND(), we donโ€™'t support the decimal digits โ€” so it is only integer rounding.

aaahh, got it.

I see in the math expressions article (linked) that you support rounding to nearest integer.

I had clicked through the link to the ROUND function which is describing the Google Sheets functionality, not AppSheet.

help.appsheet.com - Math Expressions

Math Expressions help.appsheet.com

You can have the same functionality with two decimalโ€ฆ ROUND(100*[COLUMN])/100

Right, great idea!

Editโ€ฆ you need to use decimal value in the formula like ROUND(100*[COLUMN])/100.0. For exampleโ€ฆ if the decimal value is 0.129 the sync will change the value to 0.00. When you use 100.0, it will give you the correct answer like 0.13.

Top Labels in this Space