Using Versions and Periods for dynamic comparison

Options
Ksenia.Erokhova
Ksenia.Erokhova Member, ALL USERS, GroupMember, Community Member Posts: 1 Master Anaplanner of the Year
in Planning & Modeling

Hello, My Client asked about report where they compare PL lines: Version 1 vs Version 2 for selected Quater or Year, Quater to Quater, Year to Year and they want to select 2 Versions and 2 Periods. Conditional formulas can help, but I think, they may be to heavy. I tried to create Module for Selection of Version1, Version2 and Period, to use then automapping based on construction FINDITEM(Versions List, NAME(ITEM(Versions))), but it doesnt work. What the other options to build up such a logic? Ksenia

Tagged:

Categories