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
- 5 yrs agoLast active
 - 6Replies
 - 3040Views
 
