Overview: Unlocking Insights Through Comparison
In Basis, comparing different Scenarios and Budgets is like having a financial crystal ball. It's a fantastic way to see how different plans, like a Bull or Bear case, stack up against your current live plan or a saved Budget.
How to Start Comparing in a Workbook
Finding the Scenario Picker: Look for the Scenario toolbar in the page header. It's your gateway to different Scenarios and Budgets.
Choose Your Contenders: You can select up to two additional Scenarios or Budgets to compare against the one you're currently viewing.
Setting Up Your Scenario Comparison View
Now it’s time to get your Workbook table ready for this financial face-off:
Open the 'View' Panel: Your control center for setting up comparisons.
💡 Notice that your 'View' panel has changed and the top Scenarios section now includes the newly added Scenarios you selected to compare.
Adding an Analysis: A Step-by-Step Guide
Let’s say you want to add a new Analysis, like a Budget vs Actual variance comparison.
Here’s how:
Prepare Your Analysis:
Go to the 'Analysis' section.
Click 'Add Analysis'.
Set 'Comparison 1' to your Budget scenario (for example, 2024 AOP).
Set 'Comparison 2' to 'Actuals'.
Decide if you want to see Variance Amount, % Variance, or both.
Hit 'Save'. Your Analysis (like '2024 AOP vs Actuals') will now show up.
Display Your Analysis:
Click into 'Months', 'Quarters', or 'Years'.
Toggle on the Analysis you’ve prepared.
You can also opt to show the monthly forecast from that Scenario.
Hit 'Update' to see your changes take effect in the Workbook.
Seeing It All Come Together
With these steps, you’ve successfully set up a comparison view in your Workbook. It’s a powerful way to visually dissect and understand the nuances between different financial paths and outcomes.