Expand my Community achievements bar.

Do you have questions about the migration to Adobe Business Platform? Come join our upcoming coffee break and ask away!

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.