Page 1 of 1

Is there a way to use variables in calculated columns?

Posted: Thu Dec 05, 2013 4:36 pm
by theregister
I know I can use calculated columns to do things like this:

Code: Select all

ColumnA - ColumnB
But what if I wanted to create variables asked from the user, to decide which columns I want in the calculation like this:

Code: Select all

Variable1:B , Variable2:C
Thus, allowing me to do this:

Code: Select all

Column{Variable1} - Column{Variable2}
Thus calculating in the calculated column only the columns the user selected while on the preview tab.

I know I can kinda concatenate column names like this on the SQL code, but is there a way to do it from here?

Re: Is there a way to use variables in calculated columns?

Posted: Fri Dec 06, 2013 1:35 pm
by Alex K.
Hello,

Unfortunately, it is not possible. Sorry.

Let us know if you need any additional help.
Thank you.