Metis Smart Modeling - Rules
From Metis Documentation
(→Formulas) |
(→Formulas) |
||
| Line 51: | Line 51: | ||
|- | |- | ||
| width="20%" | | | width="20%" | | ||
| - | + | Round | |
| width="30%" | | | width="30%" | | ||
| - | + | Calculates the rounded value of a numeric value according to the specified number of decimal. | |
| width="50%" | | | width="50%" | | ||
| - | + | <Result> = Round(<Numeric Value> [,<Number of Decimals>]) | |
| + | |||
| + | '''Parameter Details''' | ||
| + | |||
| + | <Result>: Integer or real rounded value of the specified numeric value. | ||
| + | <Numeric Value>: Real or currency numeric value to round. We recommend that you use the currency type in order to get reliable results. | ||
| + | |||
| + | '''Numeric Value''' | ||
| + | If <Numeric Value> is included between: | ||
| + | |||
| + | 0 et 0.49: the number is rounded to 0. For example, 3.2 is rounded to 3 (no decimal). | ||
| + | |||
| + | 0.5 and 0.99: the number is rounded to 1. For example, 3.7 is rounded to 4 (no decimal). | ||
|- | |- | ||
| align="center" colspan="3" | | | align="center" colspan="3" | | ||