Hi Team, I need to use CEILING function in my project like CEILING function in excel. I check that mendix provides round(), floor() and ceil() functions but it doesn't work for me. I have to use this function like CEILING(Number,Significance). example CEILING(0.462,0.005)=0.465 Please check attached screenshot: Is there any way to achieve this in mendix? Thanks, Samarth J
asked
Samarth Jadhav
2 answers
2
Will this do the trick for you:
ceil(200*$YourVariable) : 200
answered
Tim v Steenbergen
-1
You could try this:
round($DecimalInput,$DecimalPoints)
where $DecimalInput is your number and $DecimalPoints is the decimal precision