Can you round down in table calculations?

Knowledge Drop

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.                

Version history
Last update:
‎04-05-2021 03:32 PM
Updated by: