About Calculated Columns

Calculated columns contain figures resulting from calculations on data in other columns of the statement.

To define a calculated column, use standard spreadsheet formulas in the default column specification row. For example:

	Current Balance	Last Year Balance	Curr/ LYear
Petty cash	274.57	358.00	.77
Bank account, US dollars	8,437.54	5,932.90	1.42
Bank account, CAD dollars	4,372.96	3,665.39	1.19
Total:	13,085.07	9,956.29	1.31

In this statement, the default formula for the last column (column H on a report specification) is =(F1/G1). The formula states that this column contains the value of column F divided by column G.

When the report is generated, Financial Reporter adjusts the relative cell references on each line.

Using Currency Exchange Rates in Column Calculations

Financial Reporter can use exchange rates maintained in Sage 300 ERP, so you can create financial reports in any currency you maintain, using the exchange rates from any fiscal period.

To retrieve exchange rate information, you use the FRRATE function to get exchange rate information. For more information, and for examples of how to use this function, see FRRATE Function.

Note: The rate returned by the FRRATE function is always used as a multiplier to convert source currency to functional, even if you defined the rate as a divisor. If the rate is defined in the System Manager as a divisor, Financial Reporter returns the reciprocal of the rate.

Related Topics