In this example, I will create a new Calculated Key Figure Staffed %.
It is good practice that if any changes are required to these queries, they should be copied into the customer namespace and then changed. This is to ensure that the active version of the queries does not get overwritten by SAP delivered queries after an upgrade. In this blog we will change the SAP delivered query. Queries copied to customer namespace can be changed in the same way.
The formula for Staffed % will be as follows:
Staffed % = (Staffed Quantity/Planned Quantity) * 100
This should only be calculated for activity resource type. To achieve this, we firstly need to create two RKFs using Staffed Quantity and Planned Quantity key figures restricted to resource type 0ACT. This can be done as shown in blog on creating RKFs. Create two RKFs with the name “Staffed Quantity – Activity” and “Planned Quantity – Activity”. After creating the RKFs, to create the CKF proceed as follows:
BEx Query Designer –> Open query /CPD/AVR_MP_Q008 –> Navigate to Rows/Columns –> Right Click Structure “Key Figures” –> Click “New Formula”
Edit the formula –> Change the CKF description to “Staffed %” –> Enter the formula for Staffed % in Detail View –> Click OK –> Save the query
PCS report now shows the new RKFs and CKF and displays the staffed % only for activity resource type.