Cell-level Calculations in the Column Definition Formula field

Cell-level calculations in the Line Definition Formula field (and thereby the Calculation dialog window) are fundamentally constructed using the period (.) to delineate between column and line “Code” cell reference values. The calculation (or “placement”) is then constructed in the Line Definition Formula field referencing these cell coordinates.

Command Syntax:

[Column Definition Code].[Line Definition Code]

[Column Definition Code].[Line Definition Code] / [Column Definition Code].[Line Definition Code]

EXAMPLE:

[D].[1114]*100

This references a column and row code value in a calculation which can be “placed” it in another cell (column) location on the report.

-OR-

[A].[FIRST]+[B].[FIRST]

This uses two different column code coordinates and the same row code to return a calculated value in the column.

SAMPLE REPORT SCENARIO 1:

Based on the first syntax example above, the following details how a column and row code value in a calculation which can be “placed” it in another cell (column) location on the report.

The Line Definition includes the following:

The Column Definition includes the following:

The report without the calculation in the column Code = ‘B’ would return the following:

The report with the calculation in the column Code = ‘B’ would return the following:

In the example above, only the resulting, specific data value of this calculation will displayed on the row/column. (Also, the same value will be placed in each row for column B.)