Analyze drills down from the account line or the output line on the Accounts spreadsheet to see how the value is calculated. The heading displays the entity name and current scenario as follows:
Analyze <entity or file name>(<scenario name>)
To use Analyze:
Optional: Click a toolbar buttons to analyze different account elements:
Forecast —Access Forecast Method—see Selecting Predefined Forecast Methods and Specifying Basic Forecast Method Options.
User-Defined Accounts—Access User-Defined Accounts—see Using User-Defined Accounts.
Optional: In Analyze, double-click a formula component to analyze it further:
When you drill down to Account Input, you can change historical and forecast values, be sure to recalculate for input changes and save to retain the data.
Valid values in conditional statements are highlighted.
Close the initial Analyze dialog box.
Tip:
All subsequent dialog boxes close.