cancel
Showing results for 
Search instead for 
Did you mean: 

Creating a Prior Year Scenario

Mustafa_A
Contributor II

Hi - 

How do I create a scenario for prior year? I'm building a flux report (variance analysis) where I can compare data between different scenarios (e.g. Actual v. F9).

 

I was suggested to create this member in U8, and input a dynamic formula. However I am not sure what the code should be. If this is a route I should pursue, please advice. 

Any ideas will be appreciated. 

Thank you!

 

 

4 REPLIES 4

EricOsmanski
Contributor II

If you are just trying to view PY data of a scenario, you shouldn't need a new scenario. There are variables to retrieve prior year, such as |WFYearPrior|, |POVYearPrior|, |CVYearPrior|, etc, etc. It'll depend on how the CV is setup.

This is how I've setup my columns. Created two parameters (Scenario 1 & 2) which consists of all the scenarios. 

on the rows, I have accounts 

Mustafa_A_1-1638280858886.png

Mustafa_A_2-1638280965289.png

 

Ok - and what exactly are you trying to do?

ChristianW
Valued Contributor

Hi

The delimited list doesn't need to be one dimension only, you can easily combine it:

Display Item: None, Actual, Budget, [Actual previous year},F1,...

Value Item: S#None, S#Actual, S#Budget, S#Actual:T#|CVYearPrior|, F1...