round_upwards

The function round_upwards( ) rounds a number to the number of decimals specified with the second parameter. This function will always round upwards: 0.1 will become 1.

round_upwards ( input_number; number_of_decimals )

The result of this function is of type NUMBER: the rounded input_number.

The function has two parameters:

1. input_number, type NUMBER. The number to be rounded.
2. number_of_decimals, type NUMBER. The number of decimals to round to. A number from 0 up to and including 9.

Example

@( round_upwards( 1223.219; 0 ) ) 

Result: 1,224.00

Note that because a number is, by default, always printed with two decimals in a result document results of the function round_upwards( ) may not be shown correctly. To complicate the matter in Microsoft Word the displayed number is also rounded to 2 decimal positions.

Note that the construction @ ( ) around the function means that the result of the function is displayed in the text. This construction must be used in a text part of a model document. The switch from ITP mode to text mode in a model document is made with the # characters. An ITP model document starts in text model, the #BEGIN makes the switch to ITP mode.