Example - Compare a Measure to a Complex Expression Value

This example shows how to use conditional formatting to compare a measure to a value calculated by an expression.

In this example, you compare revenue to total costs, which you calculate using an expression that sums fixed costs, variable costs, and discount value.

Description of the illustration conditional-format-example-target-expression-1.png

Here's how to configure this example using the Conditional Formatting dialog.

• In the Name field, enter Compare revenue to costs.
• In the Measure field, select Revenue.
• In the operator list, select the equal to or less than symbol <.
• In the value box, click the down arrow, then click f(x) to display the calculation editor.
• In the Name field, specify TOTAL_COSTS_CALC, and in the calculation field specify COST_FIXED + COST_VARIABLE + DISCNT_VALUE.
  
  
  Description of the illustration conditional-format-example-target-expression-3.png
  
  
• Validate the expression and click Save.
• Click Format to display the color picker and select a red shade.
  
  Description of the illustration conditional-format-example-target-expression-2.png