using a variable in a calculated dimension

[#1]

I have an expression stored in a vriable that I would like to use as a claulted dimension.  I am having issues getting the variable to work as a calculated dimesnion (have followed other threads on the topic and followed the syntax)

since my calcualted expression has multiple results (calculting price/ton) I would also like to somehow group the results as well

I know the expression is correct because I am using it in other charts, with the correct results

[sinanozdemir]

Are you using it within an Aggr() function in your calculated dimension? Maybe an example you can post.

[marcus_sommer]

Maybe you are missing an aggr() to wrap your expression - an example of your calculated dimension would be helpful.

- Marcus

[#4]

my variable is actuall the total of 3 other variables -

$(vFreightPerTon) + $(vMaterialPerTon) +  $(vOtherPerTon)

the variable is vTotalperTon

[marcus_sommer · Accepted solution]

This won't work - have a look here what is needed for a calculated dimension: Calculated Dimensions.

- Marcus

[#6]

Marcus

thanks for the info and insight