You can find and correct errors in formulas.
Prerequisite
A table view is created for the query or the ad-hoc analysis.
Procedure
Start the query or the ad-hoc analysis.
Activate the Data tab bar.
Click in the cell with the incorrect formula.
Click Formulas > Correct error(s). The Correct error(s) dialog opens.
Specify the relevant settings and click OK.
You have corrected the error in the formula.