Expand my Community achievements bar.

Total Hours not available as filter in Project Report?

Avatar

Level 7
It seems now that if I create a Project Report, that "Total Hours" (in the project table) is not available to filter on, but I can see the field if I want to add it as a column.
2 Replies

Avatar

Level 5
While "Total Hours" isnt available as a filter, "Actual Hours" is. I think that'll get you what you want. These 2 fields frequently confuse me. If i recall, one has the word "Hours" tacked onto it and the other doesnt.

Avatar

Level 7
Actually, that's the issue - I was trying to create an "exception report" where total hours <> actual hours. I think they've been off before and I wanted to compare the two. It looks like you're right though - one has "Hours" after it and the other does not. So I just exported all current projects in Excel, mass removed " Hours" (and " Hour") from the column and then subtracted one from the other. At this time they all resulted in 0, so that's good.