Skip to main content

Hello Community,

 

I’m trying to create a crosstab report that shows resource time spent on client work(bill or not) vs. their overall time spent. We have three types of project categories: Internal, Client Bill & Client Nonbill

Formula desired = nClient Work Bill & Nonbill] / All Actual Approved]

The issue I’m running into is that the only fields available are Actual Approved, Actual Approved Billable, Actual Approved Nonbill. 

For this operation to work, I’d need to exclude projects under the Internal category from the numerator, but not the denominator.  If I implement a tab filter, to exclude Internal project time, it takes it out from all the calculations.

Does anyone have experience doing a similar calculation?

Cross tab report calculation: lClient Work Bill & Nonbill, excluding Internal projects] /p All Actual Approved Time]

Hi Kayla

Did you try using the Resource Utilization Category on work items? If you classify tasks with the relevant resource utilization category (you can edit the list of values in that pick list field) you could split out time spent per resource utilization category and report on it.

That should solve the issue.

Limor

Reply


Terms of UseCookie settings
All Data Subject Access Requests (DSARs), and requests of “Do Not Sell My Personal Information” according to the CCPA, must be submitted through the Planview DSAR portal located here

Planview has appointed a Data Privacy Officer (DPO) to be responsible for overseeing our Privacy Management Program and related privacy compliance measures. DPO can be contacted at privacy@planview.com