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?

Accepted answer
in Planning 11 comments


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.

Howdy, Stranger!

Log In

To view full details, sign in.


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