Format definitions

The format definitions in a Dynamic Report are applied based on the return value of an IF function in the format label column (typically column A) for each row in the Dynamic Report.

The IF function uses several worksheet functions. The basic logic of the IF function is as follows:

  1. Determine whether the row member is a consolidation.
  2. If the row member is a consolidation, determine whether the subset member level of the consolidation is less than or equal to the last level format definition defined in the format range.
    • If the subset member level of the consolidation is less than or equal to the defined format definitions for levels, return the subset member level.
    • If the subset member level of the consolidation is greater than the last format definition for levels, return Default.
  3. If the row member is not a consolidation, return Leaf.
The following is an example of the default IF function that is created when you convert an Exploration View to a Dynamic Report. The function TM1RPTELISCONSOLIDATED determines if the member is consolidated or not. The function TM1RPTELLEV returns the level of the member. If the level is 6 or greater, the functions returns Default. If the member is not consolidated, the function returns Leaf.
=IF(TM1RPTELISCONSOLIDATED($B$22,$B22),IF(TM1RPTELLEV($B$22,$B22)<=5,
TM1RPTELLEV($B$22,$B22),"Default"),"Leaf")

You can change the IF function. The function must return a value that can be matched to an ID in the defined format range area. After you modify the IF function, repair the Dynamic Report to apply the formatting. For more information, see Apply format definitions.