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

(Nicholas Christoffersen) #1

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?

(Praveen Seshadri (AppSheet)) #2

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.

(Nicholas Christoffersen) #3

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

(Aleksi Alkio) #4

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

(Nicholas Christoffersen) #5

Right, great idea!

(Aleksi Alkio) #6

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.