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