Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=Sum( { $ <Colour = { '*(Red)' }>} [Value] )
should work
Thank you!
Thanks - that works... but why is this needed?
maybe because '(' should be a special character into searches, * will workaround this