Perform Calculations

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 PowerPlay Web:

• add
• subtract
• multiply
• divide
• percent
• percent of base
• cumulative percent
• rollup
• exponentiate
• accumulate
• forecast

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 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.

4. In the Includes Categories box, select the categories you want to include in the calculation.
5. If you want to use a constant in the calculation, select the check box beside Number and enter the constant in the box.
6. 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.