variable + field name

[#1]

Hi All,

I have 2 field : Dollar_us and Dollar_ca.

I want to create a variable and set the variable( ie: location => (ca or us) ) to switch between this two field.

What I want to know is that how to add the variable to the end of filed?  means : Dollar &location  ????

Thanks

[erichshiino · Accepted solution]

Hi,

You can use

=Dollar_$(var) as a calculated dimension instead of a regular dimension.

I create a small sample with the same functionality

hope this helps,

Erich

[#3]

Thanks,

I was using the regular dimension instead of the calculated one.That's why I was getting the error message.

[#4]

Cool