Framework:BI-Center:Conditional Formatting

With the support of the "Conditional Formatting Assistant" you can define different styles for each measure. You open this assistant in an analysis view or an input mask from the property "StyleDefinitionObject".

The assistant contains two steps. In the first step you define the styles, in the second step you define the conditions.

In this example you define a conditional formatting for the measure "in percent". Numbers between +5% and -5% have a white background color. A variance less than -5% will be red, a variance greater than 5% will be green.

Step 1: Define your formats

You create the styles.

Input  Open the assistant and create three styles and give the names "Variance positive", "Variance negative" and "Normal".

Framework, Create styles

Input  Choose the color therefor. Choose "Next" and create three conditions and name them like the styles.

Step 2: Define your conditions

Framework, Define conditions

Input  Choose the style and as measure "in percent". Double click in the measure [in percent] in the short list und write > 5. Repeat this step for the condition "Variance negative" and "Normal".

Overview of the conditions:

Name	Style	Measure	Condition
Variance positive	Variance positive	in percent	[in percent]>5
Variance negative	Variance negative	in percent	[in percent]<5
Normal	Normal	in percent	[in percent]>=-5 AND [in percent]<=5

Hint  Please note, that floating point values should never be compared with = or <> because there could be problems with diffent roudings.

Hint  Also dimensions used as measures can be used with the COPSYS_ID of the element. E.g. [Products] = 2 checks if the element of the dimension Products is No assignement

Hint   In expressions text measures have to be in inverted commas. E.g. '[Textmeasure]'<>'' checks, if the text on the measure 'Textmeasure' not is empty.

Input  Close the assistant with "Finish".

Framework, Conditional Formatting