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

• LineNumber: This returns the number of the row in a table

• Nameof: This provides the name of the objects, usually displayed in the column header

• NoFilter: This ignores the filter applied to a table and displays the calculated value without the filter...