Rounding

Rounding is used when you want to express a number as an integer, according to the rule specified. There are two main reasons why it may be necessary to round numbers:  

• To have precise figures for calculations (e.g. number of months, weeks, etc.)

• Formatting - number of decimals to use

 

The following rounding functions are available in the Function calculator:

• ROUND - rounds (up or down) to the nearest integer

• CEIL -  rounds up to the nearest integer

• FLOOR - rounds down to the nearest integer

 

Syntax  

ROUND([node1])

CEIL([node1])

FLOOR([node1])

 

How it works

ROUND(1.49) gives 1

ROUND(1.51) gives 2

CEIL (1.49) gives 2

FLOOR (1.51) gives 1

 

Use

Rounding functions are often used in combination with NOP functions to calculate precise number of periods (months, weeks, etc.). E.g. to get the average production for a period, use rounding functions to find the correct figures.

 

Rounding functions will have no effect when Format type Duration is used.

 

Version 5.1.2.0

This document contains confidential information. Not to be copied by third parties without written authorization.

© Copyright Corporater AS - All rights reserved.