0

Round a calculation to 2 decimals

A claculation field produces a 0,001777777778 result. Any help to round this number to 0,00?

 

Nick

6 replies

null
    • Nick
    • 5 yrs ago
    • Reported - view

    Sorry, I found it,

    round(field)

     

    Nick

    • Birger_H
    • 5 yrs ago
    • Reported - view

    round(field,2)

    Birger

    • wegener57530
    • 5 yrs ago
    • Reported - view

    Is there any possibilty not ro round, but to cut off any decimals? This is for relevance for tax calculations, as the revenue offices use a different approach. I would like to continue calculating with a number such as 1,555 as 1,55 and not as 1,56 as round would give me. Any suggestions?

    • mike
    • 5 yrs ago
    • Reported - view

    floor(1.555 * 100) / 100

    • Ruben
    • 2 yrs ago
    • Reported - view

    But this doesn't produce the desired result. 

    "Any help to round this number to 0,00?"
    round(field,2) produces a result of 0 and the two decimals disappear.

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

    You can wrap it in a format function. 
    format(round(field,2),"0.00")

    Steven

Content aside

  • 2 yrs agoLast active
  • 6Replies
  • 2535Views