Share
ReportAttempting to get project task summary report to provide MTD, YTD and PTD (project to date) hours. How can we get this?
*This post is locked for comments
You’re offline. This is a read only version of the page.
Announcements
50
Attempting to get project task summary report to provide MTD, YTD and PTD (project to date) hours. How can we get this?
*This post is locked for comments
Dear Adam,
MTD = Current units , this is column 1
PTD = Project to date Units , this is column 3
PTD is YTD if a project is NOT balance foward at year end.
For budget in units:
1. Open Report in Crystal reports
2. In the field explorer pane Click on Field = Column5
3 Right click and select edit
4. Change {pjptdsum.eac_amount} to pjptdsum.eac_units}
5. Repeate proceduer for Column5
6. Change {pjptdsum.total_budget_amount} to {pjptdsum.total_budget_units}
The ETC columns will need to be changed so varience can compute on units rather than amounts.
gf1etc, gf2etc
{@Gf1column5} - Sum ({@Column3}, {pjptdsum.project})
I hope this is what you are thinking regarding hours/units on pa100
Best Regards,
Jana
#1
Community Member
136
#2
Mohamed Amine Mahmoudi
102
Super User 2025 Season 1
#3
REUser
8
All responses (
Answers (
