Understanding Common Errors

Follow the rules of syntax carefully. If formula expression syntax contains errors, error messages are returned after you validate the member formula. To get information about error messages, review the formula details on the Member Formula tab. The most common error message is "Failed to execute." This occurs when you use parameters in the expression incorrectly. These actions cause "Failed to execute" error messages:

  • Entering the wrong number of parameters in the formula expression

  • Misspelling member names, functions, or variable names

  • Not surrounding member names with quotation marks

  • Including numbers where text is required