CountRows with Filter on multiple columns

(0) Share

Report

Posted on by JanDras

Hello,

I'm trying to combine multiple conditions to the CountRows:

CountRows(Filter('Source'; Column1 = Concat(varSelected; Nadpis) && 'Column2' = startTime))

I need to get back number of rows that fulfill the two(three, four) conditions. If I do one condition at a time, it works fine but it doesn't work when I start adding criteria.

What is the proper syntax?

Thank you

All responses (5)

Answers (0)

charlessexton 878 on at

Like (0)

Report

Re: CountRows with Filter on multiple columns

Have you looked at the output from Column2 and startTime1 to make sure they're the same as each other? They will need to be the same type and format in order to match. They have to be exactly the same.
JanDras 85 on at

Like (0)

Report
Re: CountRows with Filter on multiple columns

Source:
Column1 Column2 Column3
Name1 StartTime1 EndTime1
Name2 StartTime2 EndTime2

I am trying to create an if() condition that would prevent the users creating a duplicate entry.

If I use:
CountRows(Filter(Source; Column1 = Name1))
The output is 1 (and it's right.
but once I use:

CountRows(Filter(Source; Column1 = Name1 && Column2 = startTime1))

The output is 0 but the row that matches the conditions exist.
charlessexton 878 on at

Like (0)

Report

Re: CountRows with Filter on multiple columns

When you say that it doesn't work, in what way doesn't it work? CountRows gives you an error? CountRows states there are zero items?
JanDras 85 on at

Like (0)

Report

Re: CountRows with Filter on multiple columns

Yes, I renamed it just for the sake of the post, in the original the column names do have spaces.
charlessexton 878 on at

Like (0)

Report

Re: CountRows with Filter on multiple columns

You don't need to have apostrophes on your column name unless there are spaces in it. So 'Column2' should be Column2.