Creating a Prior Year Scenario

[Mustafa_A]

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!

[EricOsmanski]

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.

[Mustafa_A]

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 

[EricOsmanski]

Ok - and what exactly are you trying to do?

[ChristianW]

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