Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Create new column with remaining hours

I need to calculate remaining hours left in a PO by contractor by month for each month of a fiscal year in a new column. Each month has a different number of working hours available and different end dates. Will this work?

 

New Column Dec Remaining Hours

Dec Remaining Hours = IF('Sep-Jun 2018 Burn Down'[End Date]>=DATEVALUE(12/31/2017),'Sep-Jun 2018 Burn Down'[ PO Hours]-('Sep-Jun 2018 Burn Down'[FY18 YTD Hours Wrk]+152)

(152 hours available to work in Dec)

 

New Column Jan Remaining Hours

Dec Remaining Hours = IF('Sep-Jun 2018 Burn Down'[End Date]>=DATEVALUE(1/31/2018),'Sep-Jun 2018 Burn Down'[ PO Hours]-('Sep-Jun 2018 Burn Down'[FY18 YTD Hours Wrk]+152+168)

(152 hours available to work in Dec and 168 hours available to work in Jan)