## 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:

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...