Possible Report Calculation Errors
During the generation of reports, error messages appear if invalid formulas are encountered. Causes for invalid formulas include:
• Invalid formula names — Each formula must have a unique name. You can use all characters, including letters, numbers, and symbols in the name. If the formula name is blank or not unique, an error message displays.
• Recursive formulas — A formula cannot be recursive, either directly or indirectly. If a formula is recursive, an error message displays.
• Syntax errors — The syntax used in the formula must be valid. If the formula contains syntax errors, such as (1 +*/ 2), an error message displays.
• Inappropriate field type — The field type selected for a predefined function must be valid. If a function can be performed only on a numeric field and you have defined a field that is not numeric, an error message displays.
• Mismatched parentheses or square brackets — If you forget an opening or closing parenthesis or use square brackets instead of parentheses, an error message displays.
Although verification of an equation does not catch a divide by zero problem, an error message displays if this situation occurs when the calculation is performed.