Need help to create a report that displays both CURRENT Projects and COMPLETED Projects for a specific month

2 replies
574 views
Translate All

Hello,

Has anyone created a report that shows both CURRENT Projects (Current Year) and COMPLETED Projects for ‘"This Month" (December)?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Madalyn_DestafneyAccepted solution

Community Advisor

Hi there, you can do this in your filters of a project report. Have a set of filters for projects in current status within X timeframe and any other filters, then create another filter set within the same report using OR (not AND) and have your other set with projects in complete in Y timeframe (if you want to show completed in Dec, would do project actual completion in Dec), and any other filters with that. Then your report will show you all projects that fall within either filter set.

If this helped you, please mark correct to help others : )

Madalyn_Destafney

Accepted solution

Community Advisor

Hi there, you can do this in your filters of a project report. Have a set of filters for projects in current status within X timeframe and any other filters, then create another filter set within the same report using OR (not AND) and have your other set with projects in complete in Y timeframe (if you want to show completed in Dec, would do project actual completion in Dec), and any other filters with that. Then your report will show you all projects that fall within either filter set.

Translate

If this helped you, please mark correct to help others : )

I

IsaDiAuthor

Level 2

Thank you, @madalyn_destafney!

That did the trick! I was grouping by Entry Date instead of Actual Completion Date.

Translate

Sign up

Login with SSO

Login to the community

Login with SSO