Knowledge Drop

Can you round down in table calculations?

  • 6 April 2021
  • 0 replies
  • 561 views

Userlevel 3
Badge

Last tested: Jun 16, 2020
 

There is a floor function that will round a number down to the nearest integer. However, to round down to a certain number of decimal places, you will need some math.

Use this formula and replace # with the number of decimal places you want to round down to:

floor(${number}*power(10,#))/power(10,#)

 

This content is subject to limited support.                

 

 


0 replies

Be the first to reply!

Reply