ROUNDDOWN
The ROUNDDOWN function always rounds a number down, toward zero. Use ROUNDDOWN for conservative estimates, like minimizing costs.
Syntax
rounddown(value, significance)
Arguments
value - Required. The number to be rounded.
significance - Optional. The number of decimal places to round off.
Example
ROUNDDOWN(Actuals,2) //Rounds the Actuals to 1 decimal place

Last updated
Was this helpful?