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.