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