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 ?
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)
3 Likes
Thank you. Now I know how to round to 2 decimal numbers.