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]