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 misc functions

Misc functions are a group of functions that can be applied for various tasks.

The most common function in this category is the IF logical operator, which we will demonstrate in this recipe, and there are other functions that can provide us additional and useful information about the report, such as report name and number of pages.

Some other functions we already discussed and demonstrated are LineNumber in the Using formulas recipe of this chapter and the forcemerge function in Chapter 8, Merging Data.

The main misc functions are as follows:

  • IfThenElse: This is an operator we can use to create a Boolean statement
  • Forcemerge: This adds the missing dimensions into the calculation context when we are synchronizing data providers ...

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