Using Google Sheet's Filter function, clarification needed-CodePudding

I am trying to filter some information with 2 conditionals (something is true and something else is >0)

Independently things work just fine:

=unique(filter(
    indirect($A$1&"!$E$3:E"),
    indirect($A$1&"!$C$3:C")=TRUE
))

gives me a list of things that are true, and

=unique(filter(
    indirect($A$1&"!$E$3:E"),
    indirect($A$1&"!$J$3:J")>0
))

gives me a list of things that are >0.

When i try to combine them, like this

=unique(filter(
        indirect($A$1&"!$E$3:E"),
        indirect($A$1&"!$C$3:C")=TRUE,
        indirect($A$1&"!$J$3:J")>0
))

I get an error No matches are found in FILTER evaluation.

What am i missing please?

PS: It goes without saying that I do indeed have things that are both true and are > 0

CodePudding user response：

for non-english locale it would be:

=unique(filter(
        indirect($A$1&"!$E$3:E");
        indirect($A$1&"!$C$3:C")=TRUE;
        indirect($A$1&"!$J$3:J")>0))