Scenario Issue

DeeWarren

For some reason, when adding a new scenario, our enrollment numbers double instead of projecting normally. This begin occuring after the roll over process.

SS with two scenarios in model. shows the same on base case

SS with only one scenario in model

Formulas

not really sure where the duplication is happening.

SIVAPRASADPERAM

Looks like the PREVIOUS(Total Enrollment Spring) formula is being evaluated separately for each Scenario. When a second scenario is added, the scenario dimension may be causing the prior-year value to be referenced twice or carried forward incorrectly.

Check:

• Whether Scenario is a dimension in both source and target modules.
• The formula behind Total Enrollment Spring.
• Any LOOKUP, SUM, SELECT, or breakback logic involving Scenario.