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

Get SAP BusinessObjects Reporting Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.