### Dataview Rounded up / down

At the moment, I’m using Dataview with `round(sum(rows.price))`

to round the sum of the price rows. What if I wanted to round the sum up / down, how can I do it ?

At the moment, I’m using Dataview with `round(sum(rows.price))`

to round the sum of the price rows. What if I wanted to round the sum up / down, how can I do it ?

There’s no `ceil()`

or `floor()`

in dataview dql.

With `round()`

, if you don’t define the number of decimal places, then it rounds to down if decimal <5 and t o up if >=5.

You can define the decimal places to more accurate results:

`round(sum(rows.price), 2)`

(for 2 decimal places)

2 Likes

Thank you. Now I know how to round to 2 decimal numbers.