Project and Portfolio Management Practitioners Forum
cancel

Find total time for a period

Highlighted
Mohit_Agrawal
Outstanding Contributor.

Find total time for a period

HI All, I need to fine total time charged for a time period, for all project, all resources... Just one number: total time charged for a period or for a year.... do you know of any report or have sql query? Thanks
1 REPLY
Erik Cole
Acclaimed Contributor.

Re: Find total time for a period

Something like this should work....

Select sum(ae.ACTUAL_EFFORT)
FROM TM_TIME_SHEETS ts
join TM_TIME_SHEET_LINES tsl on tsl.TIME_SHEET_ID = ts.TIME_SHEET_ID
join TM_ACTUALS a on a.TIME_SHEET_LINE_ID = tsl.TIME_SHEET_LINE_ID
join TM_ACTUALS_EFFORT ae on ae.ACTUALS_ID = a.ACTUALS_ID
join KTMG_PERIODS p on p.PERIOD_ID = ts.PERIOD_ID
where 1=1
and tsl.STATE != 5 -- don't include Canceled
and a.TOTALS_FLAG='Y'
AND p.start_date > to_date('1-JAN-16','dd-mon-yy')