Rounding Values with decimals to the nearest whole number

AppSheet AppSheet Q&A
, ,
1

I want to update my expressions so that they round up to the nearest whole number (taking into account the numbers after the decimal). For example, 66.67 would round to 67, 88.34 to 88, etc.

Currently, I have expressions that calculate a percentage, based on the items selected out of the total items available in a list(s). These expressions populate a percentage value that usually looks like xx.xx%. However, I added a format rule and it doesn’t seem to work for values that have a decimal, so I want to update my expressions so they rounds the percentage the nearest whole number, removing the numbers behind the decimals.

This is an example of one of my existing expressions (one of my more complicated ones):
1.0*(COUNT([Column1])+COUNT([Column2])+COUNT([Column3)+COUNT([Column4)+COUNT([Column4)+COUNT([Column5)+COUNT([Column6)+COUNT([Column7]))/31
How can I update it to round the percentage to the nearest whole number?

2

Please use ROUND() function for rounding of decimals to the nearest integer.

ROUND() - AppSheet Help

Please try

ROUND(1.0*(COUNT([Column1])+COUNT([Column2])+COUNT([Column3)+COUNT([Column4)+COUNT([Column4)+COUNT([Column5)+COUNT([Column6)+COUNT([Column7]))/31)

Please note the ROUND() will make it an integer , so you will need a number type column once ROUND() is applied.

Also you may want to elaborate the following , so that the community could offer some solution if available.

1 Like
3

FLOOR()

ROUND()

CEILING()

1 Like