Exclude text from GetFieldSelections to use in a label

[tinkerz1]

I am trying to figure out how to use an expession for a label, I know if I exclude *threshold* I will return one value, but hbow do I get to it?

={<'*Threshold*'<>{$(=GetFieldSelections([ABC],',',3)}>}

[sunny_talwar]

So you want to see your field selection in the label, but want to exclude anything which has *Threshold* in it? Is that what you question is? If yes, then try this:

=Concat(DISTINCT {<ABC = e({<ABC = {'*Threshold*''}>})>}ABC, ',')

[tinkerz1]

Ih Sorry, there is error in set modifier expression, I am still learning so cant figure it out

[sunny_talwar]

Sorry, I placed two single qoutes at the end, try this:

=Concat(DISTINCT {<ABC = e({<ABC = {'*Threshold*'}>})>}ABC, ',')

[tinkerz1]

Thank you so much I would never have found it.

[sunny_talwar]

Is it giving you the output you are looking for?

[tinkerz1]

Ok getting there thanks for this,

=if(GetFieldSelections([Issue],';',1)='temp',count(DISTINCT[ID]))

Why do I get a bad field name on Distinct.

This is also an alternate state so I assume I dont need to label this in the formula.

Thanks.