Creating a Format Rule - Reporting Dashboards - Foundation 23.1 - Foundation 23.1 - Ready - OnBase - external - OnBase/Reporting-Dashboards/Foundation-23.1/Reporting-Dashboards/Dashboard-Maintenance-and-Design/Using-the-Dashboard-Designer/Advanced-Dashboard-Design/Conditional-Formatting/Expression/Creating-a-Format-Rule - 2025-04-01

Reporting Dashboards
Platform
OnBase
Product
Reporting Dashboards
Release
Foundation 23.1
License

To format values according to the Expression condition,

  1. Click the menu button of the required data item and select Add Format Rule | Expression.The Expression dialog box is displayed, which allows you to specify the required expression.
  2. Select the value being evaluated by the expression by clicking on the blue value in brackets. This will display a list of available values.
  3. Select the operator for the expression by clicking on the green operators, which will bring up a drop-down list of available operators.
  4. Specify a static value for comparison by clicking the <enter a value> field, or by clicking the to change the field to allow comparison to a dashboard parameter.

For instance, the following image displays a Grid dashboard item whose rows are filled in green if the Extended Price value is greater than 150,000 and the Quantity value is greater than 7,500.