SECTIONSPlan Errors
If the plan encounters a problem with the formula calculating the plan cell values an error message is displayed on the plan table. You can use the details in the error messages to fix the errors.
To view each plan cell error:
- Click each individual plan cell with an error link in the Plan Line table on the Plan Lines tab.
- Click a plan cell with the type "Hash", to view the details of the error.
The table below lists the error types that are supported by the Extended Planning and Analysis application.
| Hash Code | Description |
|---|---|
| #CYCLE | Indicates the when a reference to a cell or cell range contains cyclic dependencies. |
| #ERR | Indicates the formula cannot correctly evaluate a plan cell calculation. |
| #NAME | Indicates that Extended Planning and Analysis does not recognize the function or formula name you are using. It can be caused by typographical errors in the function name. |
| #REF | Indicates that a reference to a cell or cell range is incorrect. It can be caused by deleting a cell that is referenced in a formula or by moving a cell that is part of a formula. |
| #SYNTAX | Indicates the formula contains one or more missing opening brackets. If you don’t want to enter a formula, start your text with an apostrophe (‘). |
| #VALUE | Indicates the formula contains an argument of the wrong or invalid type. For example, it can be caused by trying to perform mathematical operations with text. |