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