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.

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	Link to Financial Dimensions
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.

Example

See Also