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