Resolving Data Validation Errors

Your administrator can set up data validation rules to ensure that data meets company guidelines.

For example, your administrator can set:

• Criteria for the data you enter, called data validation rules

• Background colors to call your attention to data validation errors

• Messages that tell you what the criteria is

If the data in a form doesn’t meet the criteria in data validation rules, follow these steps to fix the errors.

To resolve data validation errors:

1. In a form with errors, hover your cursor over the cell (or on mobile devices, tap into) having a non-default colored background.

   Your administrator typically calls your attention to cells having data validation rules by displaying them with a colored background. Pop-up text displays the cell intersection and the text This cell contains Data Validation Messages.

2. Click Actions, and then Data Validation Messages.
3. If there’s more than one message, expand the list, and then click each hyperlink to go to the cell to be corrected.
4. Resolve each error based on the instructions in the data validation message.
5. When you’ve resolved all errors, save the form.

   The cells’ colored backgrounds and Data Validation Messages no longer display.

Tip:

If your Page/POV doesn't include valid members, in the member selector you can clear the current members by clicking and then Clear Page Selections. You can then select members from other dimensions that are included in the valid intersection definition.