Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Find projectscompleted in a report

Sanjai
in Finding & Searching

Featured Replies

Hi,

I have a table with the following fields:

PlannedDate

ActualDate

ProjectName

PlannedMonth

Milestone

Category

A project can have multiple milestones which would be in separate records. Same milestone can be selected for multiple projects. The project is completed if an actual date is entered.

I want to generate a report in the following format:

Category1

PlannedMonth(January 2005)

Milestone1 TotalProjects: XX ProjectsCompleted:XX Due Projects: XX

Milestone2 TotalProjects: XX ProjectsCompleted:XX Due Projects: XX

PlannedMonth(March 2005)

Milestone1 TotalProjects: XX ProjectsCompleted:XX Due Projects: XX

Milestone2 TotalProjects: XX ProjectsCompleted:XX Due Projects: XX

Category2

PlannedMonth(January 2005)

Milestone1 TotalProjects: XX ProjectsCompleted:XX Due Projects: XX

Milestone2 TotalProjects: XX ProjectsCompleted:XX Due Projects: XX

PlannedMonth(March 2005)

Milestone1 TotalProjects: XX ProjectsCompleted:XX Due Projects: XX

Milestone2 TotalProjects: XX ProjectsCompleted:XX Due Projects: XX

I have created a layout with summary parts for Category, PlannedMonth and Milestone to group the records.

To show total projects I have created a summary field "SummCountMilestone" which is a count of Milestone. Then a calculation field which results in getsummary(SummCountMilestone, Milestone).

The calculation field above displays the TotalProjects for a milestone when the data is sorted by Category, PlannedMonth and Milestone.

My question is how should I show the ProjectsCompleted and DueProjects information in the report?

Thanks in advance,

--Sanjai

  • Author

Hi Everyone,

I solved the problem. Thanks

Create an account or sign in to comment

https://fmforums.com/topic/37213-find-projectscompleted-in-a-report/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.