Skip to Content
0

How to make a roundup?

Mar 23 at 03:24 PM

19

avatar image
Former Member

Hello in my calculated columni have an issue, i can find rounddown() function or round() function but impossible to find a way to make a Roundup() i mean a round sup like :

5,6 -> 6
5,2 -> 6

Is somebody has a solution.

Thank you :)

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Bartosz Jarkowski Mar 23 at 03:28 PM
0

I think you are looking for the CEIL function:

select ceil(5.2) from dummy -> 6

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 23 at 03:49 PM
0

Yes it is in SQL language. Perfect thank you very much Bartosz!

Show 1 Share
10 |10000 characters needed characters left characters exceeded

If that works for you, please close the question and mark the correct answer that other people can benefit as well ! :)

Cheers!

0