If a user selects a smartlist member for example Prod001 (label) and numeric value of 1
Then we have a dimension with a member Prod001.
We want to make if if the user selects smartlist member, that the calc knows to do the calc on the similar member in the product dimension.
if i make a variable in the calc equal to the smarlist. How can I create a concatination of the variable plus "prod" for example. Or is there some other way?
I suppose there are a couple of ways to do this, however I would first look into the String CDF's. These will allow you to use a function to concatenate a string and a double.
Scroll towards the bottom of the link below, and download String.zip. Then install the String CDF's.
Hope this helps,