Round

Rounding numeric data is important to ensure consistency and for readability. You would also need to round data to conform to industry standards.

Inforidge offers 3 options: Round, Round Up, and Round Down.

• Use ROUND for standard rounding needs

• The ROUNDUP function always rounds a number up, away from zero. Use ROUNDUP when you always need a higher estimate, such as in budgeting or safety margins.

• The ROUNDDOWN function always rounds a number down, toward zero. Use ROUNDDOWN for conservative estimates, like minimizing costs.

Let's explore the ROUND options by applying them on the "Plan" measure.

1. ROUND

Example: 4584.38 is rounded off to 4584.40.

2. ROUNDUP

Example: 4584.38 is rounded up to 4585.00.

3. ROUNDDOWN

Example: 4584.38 is rounded up to 4584.00.