Count with multiple statements

(0) Share

Report

Posted on by marzie

Hello Community,

I have a function like this:

CountIf(IncidentsTable;'DateStarted'>=DateAdd(Today();-30;Days) && (Filter(colPlant.Value;Value = "35"))

I want to count how many records are in collection colPlant with value 35 (i've made a collection because this is a multichoice) with DateStarted in last 30 days.

There's my function for creating colPlant:

Clear(colPlant);;ForAll(colMultiPlant;Collect(colPlant;Filter(Choices(IncidentsTable.Plant);Value in Plant.Value).Value))

Can someone explain me why this isn't working?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

JasonLane 261 on at

Like
a
(0)

Report
Copy link

Link copied!

@marzie do you have an error returned that you can share? I can see 2 x ;; in the function is that where the error is prehaps?

Was this reply helpful? Yes No
marzie 2 on at

Like
a
(0)

Report
Copy link

Link copied!

I'm using ;; and ; instead of ; and , (due to region settings)

I don't have any error, there's just blank label.

When I use these two functions separately, it works. The problem arises when they are combined:
CountIf(IncidentsTable;'DateStarted'>=DateAdd(Today();-30;Days))
CountRows(Filter(colPlant.Value;Value = "35"))

Was this reply helpful? Yes No
JasonLane 261 on at

Like
a
(1)

Report
Copy link

Link copied!

Ok
try this:
CountIf(Filter(IncidentsTable;'DateStarted'>=DateAdd(Today(),-30,Days)),Value(colPlant.Value;Value = "35"))
If the value is a number and not text then change "35" to 35.

Hope this works for you.

Was this reply helpful? Yes No
iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @marzie, sorry you had to wait four months for a response - I've seen that there was no response from @JasonLane so I will try to help 🙂

Could you let me know how your colPlant and IncidentsTable are related? Is there a field in colPlant that has the date started or else that references the IncidentsTable?

Thanks,

Sancho

Was this reply helpful? Yes No