Sum multiple conditions

[Ronald]

HI,

I want to sum, but my expression dont work.

Laboratory cold be: Bayt, Bayaten, etc

sum({<Or={'Target'},Laboratory={'Bay*'}>} total)

[Or · Accepted solution]

Try double-quotes around your wildcard:

sum({<Or={'Target'},Laboratory={"Bay*"}>} total)

Also, you should really consider not naming your field "total", that is a keyword and can be quite confusing in this context.