I am creating a report which must be match the following:

Type = Minor Works AND
(Stage: 05 OR 06 AND Stage Age >= 5) OR (Stage: 07 AND Stage Age >= 10)

This is the filter I have created with the following logic but I recieve the following error:

Your filter must use parentheses around successive AND and OR expressions.

Here is the filter:

enter image description here


From your description, I can't tell if you need to use

 1 AND ((2 OR (3 AND 5)) OR (4 AND 6))


1 AND (((2 OR 3) AND 5) OR (4 AND 6))

but one of those should work for you.

| improve this answer | |
  • The second formula was the one I needed. However you got the last conditions wrong it should be (4 AND 6), the current formula will return an error because condition 6 isnt called. – Deployment Failure Jul 23 '14 at 15:37
  • edited to use condition 6 – Jagular Jul 23 '14 at 16:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.