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?
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.
User | Count |
---|---|
25 | |
25 | |
24 | |
21 | |
20 |