Using Text Functions in Conditional Replace Text

You can use text functions in a conditional format to dynamically replace displayed cell text based on cell values, member information, or headings.

To insert one or more text functions in the Replace Text field of a conditional format, perform the following steps:

1. Select the area of the grid you want to edit, and then select the target corner cell, column header, row header, or data cell.
2. Under Conditional Properties, add or edit a Conditional Format/Text definition. If you are adding a definition, specify its condition.
3. On the Conditional Format tab, click On to enable the Replace Text. Click to select and insert a text function.

   The following text functions are supported for Replace Text:

   • AncestorAlias
   • AncestorName
   • CellValue
   • HeadingValue
   • Left
   • LeftTrim
   • MemberAlias
   • MemberName
   • MemberProperty
   • Mid
   • Right
   • RightTrim

4. Select a text function and enter the required parameters. You can combine literal text with one or more text functions.

5. Click OK to save the definition.