Calculating % Hours worked for a category

HI Anonymous,

>>This seems to work, as you can see the difference in the reported %. ALthough, I feel like I may be overlooking something and an issue may surface later, but for now it seems to work so I'll take it!

I'd like to suggest you to use dynamic workdays * daily work hour to instead, it will get wrong result when you are choose multiple weeks or try to drill calculation to days level.

>>However , there must be a better way? This formula does not work in the Time Intelligent functions I use either.

Time intelligence function not suppoert calculate with complex conditions, filters or other scenario.

Maybe you can you can consider to manually define date filter range to calculate.

Time Intelligence "The Hard Way" (TITHW)

Regards,

Xiaoxin Sheng