columnnsames including []

[#1]

Hi,

i have columnnames including sqare brackets (like "Netto [T€]". How can I use them in expressions i.e. rangesum([Netto[T €]], above([....])).

Any Ideas ?

Regards

Roland

[boorgura]

Hi Roland,

if I get it right - column name you are talking is the expression name - right?

If so you can use the column reference.

like column(1)+column(2)

Let me know if it helps.

[john_duffy · Accepted solution]

Hi Roland.

You should be able to put the column names in double quotes when using them in expressions - eg. rangesum("Netto [TE]").

John.

[#4]

Hi Rocky,

thank you for your answer. Sorry, of course I mean expression names, and to be even more correct: expression labels.

I know the possibility using column(1), .... . But what if endusers rearrange the columns in the chart? Then it leads to funny results.

regards

Roland

[#5]

Hi John,

it works. Sometimes life is easy, if you know what I mean.

Thanks

Roland