cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Prodigy
Post Prodigy

Count duedate

Hello Everyone,

 

I need help please i need to show how many due Date items outstanding, for example i need to count row only those due date please like screenshot

Thanks duedate.png 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Community Champion
Community Champion

Re: Count duedate

The basic idea would be to use CountRows() on a filtered data source. Say your Due date column is called DueDate and "Outstanding" means any date less or equal to today, then this structure could do what you want

 

CountRows ( Filter ( yourDataSource, DueDate <= Today()) )

View solution in original post

Highlighted
Community Champion
Community Champion

Re: Count duedate

Add this after Today():

&& ! ( Status = "Closed" )

If Status is a Choice column you'll need to use

Status.Value = "Closed"

View solution in original post

7 REPLIES 7
Highlighted
Community Champion
Community Champion

Re: Count duedate

The basic idea would be to use CountRows() on a filtered data source. Say your Due date column is called DueDate and "Outstanding" means any date less or equal to today, then this structure could do what you want

 

CountRows ( Filter ( yourDataSource, DueDate <= Today()) )

View solution in original post

Highlighted
Post Prodigy
Post Prodigy

Re: Count duedate

Hi @Eelman

Thanks thats counting good, but i would to minus status = closed example CountRows ( Filter ( 'Shipments ', DueDate <= Today()) ) minus STATUS "CLOSED" so it does not count when i select status closed please thanks. 

Highlighted
Community Champion
Community Champion

Re: Count duedate

Add this after Today():

&& ! ( Status = "Closed" )

If Status is a Choice column you'll need to use

Status.Value = "Closed"

View solution in original post

Highlighted
Post Prodigy
Post Prodigy

Re: Count duedate

Hi @Eelman  

Thank you so much it sorted now 

 

Thanks again. 

Highlighted
Post Prodigy
Post Prodigy

Re: Count duedate

Hi @Eelman 

is there a way to use it on sum, example i have a sum field called  Shipping Fee  so i need first to count as a choice field called Shipping Method and choices are FedEx DHL UPS  so something like before first to count how many amount is for FedEx to show as a sum amount  

EXAMPLE 

FedEx $300

DHL  $120  and so on 

 

Thanks 

 

Highlighted
Community Champion
Community Champion

Re: Count duedate

Yes, it can be done like this:

ClearCollect ( colShippingCost, AddColumns( Distinct('Shipment', 'Shipping Method'), "ShipCosts", Sum( 'Shipment', 'Shipping Method' = Result)) )

Once in a collection you can then access it how you want ie gallery, labels, etc

Note: the above code is from memory and untested so it may not be 100% correct. Maybe start a new post if that happens so others could chime in and also those with similar queries can also learn
Highlighted
Post Prodigy
Post Prodigy

Re: Count duedate

Hi @Eelman 

 

i figured already out that thanks but my question now is how can i sum 2 weeks.

Helpful resources

Announcements
Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (6,881)