And OR Conditions

[Andrea28]

Hi I am trying to write the below condition but getting error: of missing } , even though I have checked all brackets

count({<[a]={'Error found'}> + <[b]={'Error found'}> + <[c]={'Error found'}> + <[d]={'Error found'}> + <[e]={'Error found'}> + <[f]={'Error found'}> + <[g]={'Error found'}> + <[h]={'Error found'}> + <[i]={'Error found'}> , <[test]={'No errors'}>} distinct [Work Units])

Could anyone help check please? Thanks so much

[rubenmarin]

Hi, you have a comma instead of a + (or *) before test, also check that all field names are loaded in the data model

[rubenmarin · Accepted solution]

That's not the correct syntax, comma is used as an and inside  each <> block, the do it outside you can use *:

count({(<[a]={'Error found'}> + <[b]={'Error found'}> + <[c]={'Error found'}> + <[d]={'Error found'}> + <[e]={'Error found'}> + <[f]={'Error found'}> + <[g]={'Error found'}> + <[h]={'Error found'}> + <[i]={'Error found'}>) * <[test]={'No errors'}>} distinct [Work Units])

[Andrea28]

Thank you so much Rubenmarin!