Correct error(s) in formular

You can find and correct errors in formulas.

Prerequisite

A table view is created for the query or the ad-hoc analysis.

Procedure

  1. Start the query or the ad-hoc analysis.

  2. Activate the Data tab bar.

  3. Click in the cell with the incorrect formula.

  4. Click Formula Formulas > Correct error(s). The Correct error(s) dialog opens.

  5. Specify the relevant settings and click OK.

You have corrected the error in the formula.