0

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

null
    • SMoore
    • 5 yrs ago
    • Reported - view

    Round down that is

    • Birger_H
    • 5 yrs ago
    • Reported - view

    The function is

    –––
    floor('Number field')
    –––

    Birger

    • Mconneen
    • 5 yrs ago
    • Reported - view

    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.

    • MECHealthIT Consulting Ltd
    • Peter_Marsh
    • 4 yrs ago
    • Reported - view

    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)

    • MECHealthIT Consulting Ltd
    • Peter_Marsh
    • 4 yrs ago
    • Reported - view

    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)

    • Ninox partner
    • RoSoft_Steven.1
    • 4 yrs ago
    • Reported - view

    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) => 12300

    floor(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
  • 2999Views