Dynamic Select - Multiple Columns

[furlonla]

Hi,

I am looking for a way to dynamically select multiple columns using the contains expression. Currently I have this and it is working for that criteria:

However, I would also like the output to contain any columns that have the word 'Total' in them. I am not sure how to type this expression or if it is possible.

Any help on this would be really appreciated.

Thanks,

Laura

[TheOC · Accepted solution]

hi @furlonla 

Please try the following as your formula:
Contains([Name], 'GROSS , MASTER, Gross, P&L') or Contains([Name], 'Total')

the function OR allows it to select, if it meets either criteria (or both).

Cheers,
TheOC

[mbarone]

Do you mean any column with the word Total in the column name, or do you mean any column with at least one VALUE of "Total"?

[furlonla]

This worked, thank you

[Bhanu04]

I am trying to do the latter and unable to get correct results. tried something like this

if contains(tostring([name]= 'abc'),'ghj)

then  [fieldnumber] in (2)

else  [fieldnumber] in (3)

endif

this works perfectly in a formula tool but agenda is to dynamically select columns.