#### Overview of this book

Credits
www.PacktPub.com
Preface
Free Chapter
Working with the BI Launch Pad
Creating New Queries
Working Inside the Report
Working with Tables
Working with Charts
Formatting Reports
Filtering the Report Data
Using Formulas and Variables
Using Drill
Scheduling Reports
Working with BI Workspaces
Web Intelligence Rich Client
Index

## 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 each year's ranking based on the Net Sales measure.

The rank formula will use two parameters: the measure that we require to rank and the dimension that we want to base our ranking on.

The formula syntax is =Rank([Gross Sales];[Year]).

The...