You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Populate a Smart List with a Parent of a value from another Smart List

in Planning 10 comments

Summary: I have two Accounts, ProjectChild & ProjectParent. Both have Data Types of Smart List and both Smart Lists are referring to Dim members in the Entity Dimension.

SL_EntityL0 refers to Level 0 Entities and

SL_EntityL1 refers to Level 1 Entities.

Based on the value selected in Account ProjectChild from SL_EntityL0, I want to calculate the value for ProjectParent.

It should show the SmartList entry for the Parent of the member selected in ProjectChild

Does anybody have a calculation for this as I've tried and can only generate errors or incorrect answers :-(

I've also tried freeform text but I can't get that to work either

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!