Calculating at the Cell Level

You can create a custom cell-level formula on cells in a formula row or column.

Figure 4-31 shows an example of a cell that is calculated to display the % variance. Cell D4 displays the % variance between the sum of "Jan" and the sum of "Feb"; specifically, ((356-350)/350) *100=1.71%. A cell level formula gives the intended result by placing a custom formula in the cell D4. The formula needed to get the correct result is (([B]-[A])/[A])* 100.

Figure 4-31 Reason for Using Cell Level Calculation

To calculate at the cell level:

1. Select a formula cell or cells.
2. In the formula bar at the top of the Report Designer, click , and perform an action:

   • Select Use the Column/Row Formula to use the default formula for the column or row.

   • Select Custom Formula to create your own formula. Enter the formula in the formula text box to the right, or click to select from a list of formulas.

   See Using the Formula Bar.