Is there a way to use variables in calculated columns?
Posted: Thu Dec 05, 2013 4:36 pm
I know I can use calculated columns to do things like this:
But what if I wanted to create variables asked from the user, to decide which columns I want in the calculation like this:
Thus, allowing me to do this:
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?
Code: Select all
ColumnA - ColumnB
Code: Select all
Variable1:B , Variable2:C
Code: Select all
Column{Variable1} - Column{Variable2}
I know I can kinda concatenate column names like this on the SQL code, but is there a way to do it from here?