Book Image

SAP BusinessObjects Reporting Cookbook

By : Yoav Yohav
Book Image

SAP BusinessObjects Reporting Cookbook

By: Yoav Yohav

Overview of this book

Table of Contents (21 chapters)
SAP BusinessObjects Reporting Cookbook
About the Author
About the Reviewers

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