Setting the Threshold Value

This section enables you to select the Threshold Values for variance conditional formatting (Variance in % ), the selected range of Threshold Values are used in various reports of the Balance Sheet Dashboard.

For Conditional Formatting, you can define a particular threshold range of values to a particular color code. Based on the conditional formatting, you can customize the visual appearance of threshold value. These threshold values are symbolically represented in different forms such as: Color of a tile, Flags, and along the arc of a Gauge. For more information, see Oracle Financial Management Analytics User’s Guide.

  To set the Threshold Values for variance conditional formatting (Variance in % ), perform these steps:

  1. Select a value in the Red color line. If the variance percentage is lesser than the specified value, then those values are symbolically represented in Red color. For example: Red Flag.

  2. Select a value in the Yellow color line. If the variance percentage range is in between the specified values, then those values are symbolically represented in Yellow color. For example: Yellow Flag.

    Note:

    The value in the Green color line is auto populated based on the value selected in the Yellow color line.

    If the variance percentage is greater than the specified value, then those values are symbolically represented in Green color. For example: Green Flag.

    Select the required Threshold Value for variance conditional formatting (Variance in % )