Hello,
I’m trying to build up some math expressions, but I can only find expressions that take divide operations between two number and Round them to an integer (floor, ceiling). Is there a way to ha a Divide operation between two values and have the result RoundUp the last 2 digits?
(just like RoundUp(10/7,2) = 1.43)
Thank you,
Sorin
Solved! Go to Solution.
CEILING(100*10/7.2)/100.0 will do that
Ceiling(10/7,2) should work, you might need to encapsulate the division operation in its own set of parentheses though.
Nope, it doesn’t work
CEILING(100*10/7.2)/100.0 will do that
Smart
See also Virtual columns giving wrong answers.
I was lucky, I did have a decimal column part in the formula but really good to know, thank you
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |