When the row in a row definition has a Format Codeof CAL, and you enter a mathematical calculation in the Related Formulas/Rows/Unitscell, you must also enter either the letter of the associated column and row in the report, such as A.120to denote column A, row code 120, or you can use the at sign ( @) to indicate all columns. For example, you can enter @120to denote all columns in row 120.

Any mathematical calculation that does not have a column letter or an at sign ( @) is assumed to be a real number.

Note

If you use a label row code to reference a row, you must separate the column letter from the label with a period (.). For example, A.GROSS_MARGIN/A.SALES.

The at sign ( @) does not require the period separator. For example, @GROSS_MARGIN/@SALES.

# Example

The following is an example of a row definition that shows a total that includes a calculation.

Row Code

Description

Format Code

Related Formulas/Rows/Unit

Print Control

Row Modifier

340

Cash at Beginning of Period

NP

BB

+Account=[1100:1110]

370

Cash at Beginning of Year

CAL

E=C.340

NP

400

Cash at Beginning of Period

TOT

340+370

In this example, the calculation formula E=C.340means that the calculation in the cell in column C, row code 340 is performed only on column E.

Note

When you reference a column in a calculation formula, the at sign ( @) is not required.