The Project Information report summarizes all of your project information, including your project’s budget, cost, completion date, effective period, and project metrics.
Fields
| Field Name | Group by | Sort Order | Totals |
|---|---|---|---|
| Name | |||
| Start Date | |||
| Completed Date | |||
| Priority Level | |||
| Budgeted Hours | |||
| Budgeted Amount | |||
| Actual Hours | |||
| Actual Amount | |||
| % Complete | |||
| % Time Elapsed | |||
| Product Group | |||
| Product Module | |||
| Project Type | |||
| Project Client | |||
| Project Phase | |||
| Account # | |||
| IFRS | |||
| Clock Code | |||
| XRef Code | |||
| Ledger Code | |||
| Certified Payroll Project Number |
Custom Fields
% Complete
The % Complete custom field displays the completion percentage of the project. It uses the following expression:
CASE WHEN Project.PctComplete * 100 > 100 THEN '100.00%' ELSE CAST(CAST(Project.PctComplete * 100 AS DECIMAL(5,2)) AS VARCHAR(MAX)) + '%' END
% Time Elapsed
The % Time Elapsed custom field displays the percentage of time elapsed based on the project’s start and due dates. It uses the following expression:
CAST(CAST((CAST(GETDATE() AS DECIMAL) - CAST(Project.StartDate AS DECIMAL)) / NULLIF((CAST(Project.DueDate AS DECIMAL) - CAST(Project.StartDate AS DECIMAL)),0) * 100 AS DECIMAL (9,2)) AS VARCHAR(MAX)) + '%'