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
- 4 yrs agoLast active
 - 6Replies
 - 2558Views
 
