Add Calculations

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

You can perform the following types of calculations in PowerPlay Web:

• Arithmetic: add, subtract, multiply, divide, exponentiate
• Percentage: percent, percent of base, cumulative percent, percent growth
• Analytic: average, median, maximum, minimum, percentile, rollup
• Financial: forecast, exponentiate

Steps

1. In the PowerPlay Web 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 Type box, select the type of calculation you want to perform.
3. In the Operation box, select the calculation you want to perform.
4. 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.

5. In the Includes Categories box, select the categories you want to include in the calculation.

Note: Decide whether you want to include or exclude zero-suppressed categories in your calculation. Suppressing zero values while still including them in your calculation may confuse other consumers of your report.

6. If you want to use a constant in the calculation, select the check box beside Number and enter the constant in the box.
7. If you want to move the calculation, select the Movable check box.

For more information about moving calculations, see Move Calculations.

8. Click OK.

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

Tip: You can also use the Calculation button on the PowerPlay Web toolbar to insert a calculation.