You can refer to a specific report cell by typing a column letter and a row code. For example, B.100refers to column B, row code 100.

You can divide a whole column by a specific report cell amount that is in the same column. For example, the calculation B/B.100means that the entire column Bshould be divided by the value in column B, row code 100.

If the calculation references a column that is dependent on another column, the dependent column is resolved first. If you refer a column to another column that, in turn, refers back to the first column, a circular reference error results.

Note Note

This calculation might be incorrect if you change the calculation priority for the report. You can set the calculation priority on the Settingstab of the report definition.

See Also