Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

How can I convert a member to a string to populate a Smart List value?

in Planning 11 comments

Summary:

I am trying to derive a Smart List value using a member, where the Smart List has been build from the Period dimension.

Content (required):

Below is an example of the code:

"Account1" = @CalcMgrDoubleFromString(@NAME("Aug"));

"Account1" is an account containing a Smart List.

"Aug" is a value within the Smart List that has been built from the Period dimension. When I use the above code I'm getting a value of 0 as opposed to the Smart List value "Aug".

I eventually want to use the UDA associated with the Period member "Aug" that will have a reference of "08" which will drive the eventual period member selection to derive the value within the Smart List. This would have been easy if I could create the Smart List manually using the IDs I can control but the downstream calculations require that the Smart List be built from the Period dimension.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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