Metis Smart Modeling - Rules
From Metis Documentation
(→Rule types) |
(→Formulas) |
||
| Line 702: | Line 702: | ||
0.5 and 0.99: the number is rounded to 1. For example, 3.7 is rounded to 4 (no decimal). | 0.5 and 0.99: the number is rounded to 1. For example, 3.7 is rounded to 4 (no decimal). | ||
| + | |- | ||
| + | | width="20%" style="border-style: solid; border-color: grey; border-width: 0 1px 1px 0" | | ||
| + | '''RoundUp''' | ||
| + | | width="30%" style="border-style: solid; border-color: grey; border-width: 0 1px 1px 0" | | ||
| + | Calculates the upward rounded value of a numeric value according to the specified number of decimal. | ||
| + | | width="50%" style="border-style: solid; border-color: grey; border-width: 0 0 1px 0" | | ||
| + | <Result> = Roundup(<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 and 0.99: the number is rounded up to 1. For example, 3.7 is rounded to 4 (no decimal). | ||
| + | |- | ||
| + | | width="20%" style="border-style: solid; border-color: grey; border-width: 0 1px 1px 0" | | ||
| + | '''RoundDown''' | ||
| + | | width="30%" style="border-style: solid; border-color: grey; border-width: 0 1px 1px 0" | | ||
| + | Calculates the downward rounded value of a numeric value according to the specified number of decimal. | ||
| + | | width="50%" style="border-style: solid; border-color: grey; border-width: 0 0 1px 0" | | ||
| + | <Result> = Rounddown(<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). | ||
|- | |- | ||
| width="20%" style="border-style: solid; border-color: grey; border-width: 0 1px 1px 0" | | | width="20%" style="border-style: solid; border-color: grey; border-width: 0 1px 1px 0" | | ||
| Line 949: | Line 983: | ||
|- | |- | ||
|} | |} | ||
| - | |||
| - | |||
=== External Selection=== | === External Selection=== | ||