Member formula to populate intersection based upon SmartList
Hi there - I've created a smart list (sl_Project) with the following entries:
ID Name
1 Proposed
2 Deferred_P1
3 Deferred_P2
4 Deferred_P3
In my planning form, I inserted a column where I would assign a smart list entry to a member of the Project Dimension. The smart list is associated with a member of the Account dimension ("Project Status").
Ultimately, I would like to take all data that is at the intersection: "Final"->"Committed"->@currmbr("Project") for that project, and have it dynamically be placed in the "Proposed"->"Committed"->@currmbr("Project") intersection. This is all based upon the Proposed smart list selection. I created a member in my Version dimension (Proposed) and have created the following member formula for this member. The Proposed member is dynamically calced. Of course this isnt working, and was hoping for someone to assist. Thanks