O'Reilly logo

SAP BusinessObjects Reporting Cookbook by Yoav Yahav

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using formulas

Formulas can be used whenever we need to add an additional calculation to the data or use an in-built function from the function libraries.

Let's take a look at how we can create different types of formulas, which will serve different purposes in our reports.

Getting ready

Our report data contains the Number of Customers and Number of Orders measures and the Country and Region dimensions; we want to add an average calculation that will display the average number of orders.

We first add a column to the right-hand side of the Number of Orders column using the right-click menu and by navigating to the Insert option and then choosing Insert column on right, as shown in the following screenshot:

After adding the new empty column, we mark ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required