Reporting : Better boolean condition on filters

That would be a cumulative condition. In Javascript it's:

if (A === 1 && B === 1 && (C === 1 || D === 1)) {
  A & B are true & either C or D is true
} else {
  Either A or B is not true or C and D is not true
}

Python is similar:

if A == 1 and B == 1 and (C == 1 or D == 1):
    print("The condition is True.")
else:
    print("The condition is False.")

 The if statement checks three conditions:

1. A == 1: A is equal to 1.
2. B == 1: B is equal to 1.
3. (C == 1 or D == 1): Either C is equal to 1 or D is equal to 1.

For the provided values, A and B are both equal to 1, and D is also equal to 1. So, the overall condition will be True, and it will print "The condition is True." If any of the conditions are not met, it will print "The condition is False."

Thanks @randyroberts !

You did cleanly reformulate what I wanted to do with filters of reports in Workfront !

But I meant was that actually it's not possible to create those cumulative conditions with the interface of Workfront's filters.

You did used JavaScript and Pythons as example but my idea was to impement this function directly inside WorkFront filters without passing by the text mode !

That's correct. You cannot do this with text mode or the filter "wizard".

I showed this example to make it known that most other languages have this feature and to let folks know exactly what is being requested.