Databases Reference
In-Depth Information
7.
Once the attribute is highlighted, go to the
Definition
pane to the right
and click on the ellipsis button to bring up the corresponding
Edit
Expression
window.
The expression we will define for this attribute is as follows:
If([Load Factor %] >= 0.85, Green(),
If([Load Factor %] >= 0.70, LightBlue(),
LightRed()))
8.
Click on
OK
to close the
Edit Expression
dialog.
Notice how we are not recalculating the
Load Factor %
value but instead referencing the actual expression we
created in the previous step, using the label we set. This
will help us save some valuable CPU resources.
9.
Next, highlight the
Text Color
attribute for the
Load Factor %
expression
and, in the
Definition
pane, type
White()
. This will ensure that the cell
text uses a white color to make it more readable within the three different
background colors we previously defined.
The "conditional formatting" functionality presented
here can also be accomplished using the
Visual Cues
tab
of the
Chart Properties
window. However, the
Visual
Cues
option only supports up to three levels. Using the
expression's attributes, we can define a more complex
formatting condition, with four or more levels.
10. Click on
Next
six times until you get to the
Number
dialog window; set the
following format to our expression:
°
Fixed to 2 decimals
°
Show in percent (%)
11. Click on
Next
three times to get to the
Caption
dialog window and enable
the
Auto Minimize
option.
12. Click on
Finish
.