topic Re: And OR Conditions in Management & Governance

And OR Conditions

Andrea28 — Thu, 03 Nov 2022 07:00:46 GMT

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

Re: And OR Conditions

rubenmarin — Thu, 03 Nov 2022 07:12:00 GMT

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

Re: And OR Conditions

rubenmarin — Thu, 03 Nov 2022 08:12:28 GMT

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])

Re: And OR Conditions

Andrea28 — Thu, 03 Nov 2022 08:15:31 GMT

Thank you so much Rubenmarin!