Click here to skip navigation
OPM.gov Home  |  Subject Index  |  Important Links  |  Contact Us  |  Help

U.S. Office of Personnel Management - Ensuring the Federal Government has an effective civilian workforce

Advanced Search

Skip FedScope Help Banner, Top Navigation Links

FedScope - Help

Help Main Interfaces
Enhanced  | 
Generic
 

Enhanced Interface

Perform Calculations

<<  11 of 24  >>

You can combine rows or columns to obtain a new item based on a custom calculation.  For example, your report shows quarters for the year.  You can add new items showing the cumulative percentage each quarter contributes.  After a new calculated category is added, you can add other calculations using an existing one.

You can perform the following calculations in FedScope:

  • add
  • subtract
  • multiply
  • divide
  • percent
  • percent of base
  • cumulative percent
  • rollup
  • exponentiate
  • accumulate
  • forecast
Steps
  1. In the FedScope display, right-click the row heading or column heading for which you want to perform a calculation, and then click Insert Calculation.
  2. In the Operation box, select the calculation you want to perform.
  3. In the Calculation Name box, type a name for the calculation.
    This name will appear as the row or column heading for the new calculation.
  1. In the Includes Categories box, select the categories you want to include in the calculation.
  2. If you want to use a constant in the calculation, select the check box beside Number and enter the constant in the box.
  3. Click OK.

The new calculated category appears in italicized text in the display.

Dimension Viewer Title/Navigation Bar
Dimension Line
Display Area
Calculations Window
FedScope Toolbar
Tip
  • You can also use the Calculation Calculation Icon button on the FedScope toolbar to insert a calculation.
<<  11 of 24  >>

Help Main | Enhanced Interface | Generic Interface
Close Window Questions/Comments to: FedScope@opm.gov