Viewing the resulting formulas of the calculation
When the Global Calc process is completed, the results are shown in the Resulting Formulas grid.
- Records Per Page
- You can change the number of records per page by specifying a value here.
- Level Column
- Level of hierarchy.
Level 1- Formulas that consume only items and those items that are not associated with a master formula. No sub-formulas or intermediate formulas.Level 2- Formulas that consume Level 1 formulas.Level 3- Formulas that consume Level 2 formulas.
- Message Text
- This column remains blank until a formula calculation ends in a Warning or Failed status.
- Sequence
- Calculate in this order.
- Status
- Status of Formula Calculation
- Staged (0) = ready to be started. These are the selected formulas, ready to be started before the calculation process begins.
- Queued (1) - Waiting to be processed after the calculation process starts.
- Complete (2) = Successfully calculated.
- Failed (3) = Process could not open the formula or save it. Check Where Used to see formulas that have not calculated correctly.
- Cancelled (4) = cancelled job.
- Warning (5) = alert from Calc or Save. Formula was saved, but the calculation returned message. The first message is displayed in the Message column of the results grid. Other messages are sent to the database. Check Where Used to see formulas that have not calculated correctly.