Set analysis brackets elements '(Red)'

[#1]

Hi, I am working on a set analysis and the elements of one field are in brackets like (Red).

I am trying to get:

=Sum( { $ <Colour = { '(Red)' }>} [Value] )

but it doesn't seem to be working.

Has anyone come across similar problem before?

Thanks,

Izabela

[Clever_Anjos · Accepted solution]

=Sum( { $ <Colour = { '*(Red)' }>} [Value] )

should work

[#3]

Thank you!

[AlexOmetis]

Thanks - that works... but why is this needed?

[Clever_Anjos]

maybe because '(' should be a special character into searches, * will workaround this