SAP BusinessObjects Reporting Cookbook

Using numeric functions

Numeric functions can be used to perform mathematical calculations and common calculations such as rounding and ranking.

The main numeric functions are as follows:

• Abs: This returns the absolute value of the number (this is useful if we have negative values that we need to display as positive)
• Ceil: This rounds up a number
• Floor: This rounds down a number
• Mod: This returns the remainder from a division calculation
• Round: This rounds a number according to the level of rounding
• Tonumber: This converts a string into a number
• Truncate: This truncates a number according to the number of digits we require to truncate
• Rank: This ranks a measure by dimension

How to do it...

Perform the following steps:

1. We create a rank function that will display ...