Rounding Formula
I have a formula currently
sum(Payments.Paid)
I want to round this to the nearest cent ($0.00) how do I write the formula for that?
6 replies
-
Round down that is
-
The function is
–––
floor('Number field')
–––Birger
-
Thanks for hte "floor"... The manual is incorrect.. https://ninoxdb.de/en/manual/calculations/mathematical-functions
It says
round( x ) rounds x to the nearest whole number.
round up( x ) rounds x up.
round down( x ) rounds x down.
-
I am tryig to get a round down function to work. I want the interger part of a calculation (the characteristic) , not sure what floor is giving me
My work around has been this so far:
round('Formula total/11' - 0.51)
-
I am trying to get a round down function to work. I want the interger part of a calculation (the characteristic) , not sure what floor is giving me
My work around has been this so far:
round('Formula total/11' - 0.51)
-
From the manual:
round(x) – Rounds a number to the nearest integer.
round(x, digits) – Rounds a number with the given amount of digits.
| round(1.234, 2) => 1.23
| round(12345.987, -2) => 12300floor(x) – Rounds a number DOWNWARDS to the nearest integer.
ceil(x) – Rounds a number UPWARDS to the nearest integer.
Content aside
- 4 yrs agoLast active
- 6Replies
- 3025Views