Using Analyze

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:

  1. Highlight an account or value.

  2. Double-click the cell.

  3. Optional: Click a toolbar buttons to analyze different account elements:

  4. 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.

  5. Close the initial Analyze dialog.