Calculating at the Cell Level

A cell in a formula row or column can contain a formula. You can create a custom cell-level formula on cells in a formula row or column. When you select a formula cell, the Cell Properties sheet allows you to choose a calculation preferences:

The following table 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.

Table 18. Reason for Using Cell Level Calculation

  

A

B

C

D

 

Total Corp

Jan

Feb

Var

%Var

1

Cola

100

105

5

5.00%

2

Root Beer

200

203

3

3.00%

3

Grape

50

48

(2)

(4.00%)

4

[1].sum

350

356

6

1.71%

  To calculate at the cell level:

  1. Open a report.

  2. Select a formula cell or cells in which you want to enter a formula.

  3. In the Calculation order area of the Cell Properties sheet, select one of the following options:

    • Select Use the row formula to apply the the row calculation to the cells.

    • Select Use the column formula to apply the column calculation to the cells.

    • Select Use a custom formula to add a new formula, perform the following actions:

    1. Go to the formula bar and select a function from the function drop-down menu.

    2. With your cursor in the formula text box, complete the formula.

    3. Select File, and then Print Preview to see the results of your formula.

      Note:

      You can select multiple contiguous formula cells in a formula row or column to change the calculation order.