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 conditional-format-example-target-expression-1.png follows Description of conditional-format-example-target-expression-1.png follows](img/conditional-format-example-target-expression-1.png)
Description of the illustration conditional-format-example-target-expression-1.png
![Description of conditional-format-example-target-expression-1.png follows Description of conditional-format-example-target-expression-1.png follows](img/conditional-format-example-target-expression-1.png)
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
. - 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