Maths functions

ROUNDVAL – Round a given value

185 views June 1, 2018 admin 0

Overview

This Custom Field rounds a given value.

Syntax

ROUNDVAL(Value,Precision,TRUEFALSE)

Element Description
Value The value to round.
Precision The number of decimal places to round to.
TRUEFALSE Remove trailing zeros.

Example

IF(FIELDVAL(value), >,
999999999.999,CONCAT(ROUNDVAL(DIV(FIELDVAL(value),1000000000),2,TRUE), '
Billion'),IF(FIELDVAL(value),
>, 999999.999,CONCAT(ROUNDVAL(DIV(FIELDVAL(value),1000000),2,TRUE), '
Million'),FIELDSTR(value)))

See also

Was this helpful?