ROUND
Basic Overview
Description | Rounds each value of the input node to the specified number of decimal digits. |
Signature | ROUND(Node [, RoundingMode [, Scale]]) |
Parameters |
|
Example
DecimalNode
Year | Revenue |
2013 | -24.50 |
2014 | 95.99 |
2015 | 100.0 |
2016 | 133.33333333333 |
Output ROUND('DecimalNode')
Year | Revenue |
2013 | -25 |
2014 | 96 |
2015 | 100 |
2016 | 133 |
Output ROUND('DecimalNode', "UP")
Year | Revenue |
2013 | -25 |
2014 | 96 |
2015 | 100 |
2016 | 134 |
Output ROUND('DecimalNode', "DOWN", -1)
Year | Revenue |
2013 | -20 |
2014 | 90 |
2015 | 100 |
2016 | 130 |