Table of Contents
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)))