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