Define List Calculations

You can perform two types of calculations on any list row:

1. Modify the results of the rollup on the row (applies if the rollup Criteria is defined for the row)
2. Calculate values from other rows (applies if the rollup Criteria is not defined for the row)

Case 1: Label has Criteria defined

If you place a calculation in the Row Calculation column, the value of the rollup will be modified directly. Use the Apply Operation command to easily apply operations to multiple rows of the list.

Case 2: Label has no Criteria defined

In this case, the Row Calculation is any supported calculation of the labels. The most common scenarios are:

1. Summing other labels. In this case, hold down the shift key while selecting labels in the 'List label' control in the formula editor. The result will be the syntax for summing the labels. For example: [LABEL A] + [LABEL B].
2. Subtracting. In this case, change the sign of the operation in the calculation: [LABEL A] - [LABEL B].
3. Percent: [LABEL A]/([LABEL A] + [LABEL B]).

In general, you can enter any expression using +, -, *, /, (, ). The row calculation also supports built-in functions (as listed in the visual assist for the Row Calculation column in the Math Calculations category). These row expressions are referred to as the Default Expression. You may apply these expressions to numeric columns in your report or derive Secondary expressions to do more sophisticated calculations as well (See Define secondary expressions)