Validation of input data

The following measures support the validation of data input:

• Number (default validation is > 0)
• Sum
• Calculation

How to add a validation rule

To add a validation rule to a measure, follow these steps:

Step 1: Click the measure and click “Show” in the advanced section.

Step 2: At the bottom, click “Add validation rule”.

Step 3: Choose the operator. The options are: <, <=, =, =>, >.

Step 4: Choose the value to evaluate the measure against.

“Add validation rule” in the advanced settings

Example: Setting limits relative to a number

• One validation rule makes sure the value that is entered is not a negative value.
• One validation rule makes sure the value doesn't exceed 100.

Percentage values are often requested from Reporters. To ensure that the value entered is between 0 and 100, add two validation rules.

Two validation rules that keep the value between 0 and 100

Example: Setting a top limit relative to other data inputs

Choose “Other measure” when adding the validation rule, and pick a measure in the dropdown list.

For example, control X (the control with the validation rule) must be greater than or equal to control Y.

Validation rule using “Other measure”