Welcome to Catalog Tips
Search more than 200 articles to learn more about creating and automating your product catalogs
Tip: Start typing in the input box for immediate search results.
ROUNDVAL – Round a given value
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)))