How is % Expended calculated in Open Workbench (OWB) and the CA PPM application?
In Open Workbench, the calculation includes cost rates for all types of resources.
At the Assignment level: (actual hours * billing rate) / [(actual hours + ETC hours) * billing rate]
actual hours / (actual + ETC hours)
Billing Rate comes from the Rate Matrix Extraction table (NBI_PROJ_RES_RATES_AND_COSTS) general Actual Cost Rate where task_id = -1
At the task level everything is converted to Cost, then the division is done.
In other words, calculate each assignment for the task: actual hours * billing rate and total usage * billing rate. Add all actual costs for the task, add all total usage costs for the task, then divide.
CA PPM application:
In the CA PPM application, the % Expended field does not use cost rates and it is limited to the labor resources only.
The calculation is actual hours/ total usage hours.