Background Information
The Remaining Availability field does not appear in the PivotTable Field List dialog; therefore, you cannot insert this field into any Portfolio Analyzer view. The only way to display the Remaining Availability field in a Portfolio Analyzer view is to create a custom calculation for this purpose. The formula for calculating Remaining Availability is:
Remaining Availability = Availability - Work
Resolution
The Project Server administrator should perform the following steps to create the Remaining Availability custom calculation in existing Portfolio Analyzer view:
1. Log into PWA with administrator permissions
2. Click Admin > Manage Views
3. Select the View in question and click the Modify View button
4. On the PivotTable toolbar, click the Calculated Totals and Fields button, and then select the Create Calculated Total menu item
5. Name the custom calculation Remaining Availability
6. Click the pick list to the right of the Insert Reference To button and select the Availability (Total) field
7. Click the Insert Reference To button to insert the Availability field into the formula
8. Select the text area of the Calculation section and enter the minus sign to the right of Availability field
9. Click the pick list to the right of the Insert Reference To button and select the Work (Total) field
10. Click the Insert Reference To button to insert the Work field into the formula
The system should display [Measures].[Availability]- [Measures].[Work] as the formula.
11. Click the Change button when you complete the formula to display the results in the Data fields drop area
12. Select the Format tab in the Commands and Options dialog
13. In the Number field, type “#,##0.0” (without the quotes) as the number format
14. Close the Commands and Options dialog