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
-
Sorry, I found it,
round(field)
Nick
-
round(field,2)
Birger
-
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?
-
floor(1.555 * 100) / 100
-
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. -
You can wrap it in a format function.
format(round(field,2),"0.00")Steven
Content aside
- 3 yrs agoLast active
- 6Replies
- 2545Views