Calculations are more complicated than totals. A calculation formula can include the +, , *, and / operators along with IF/THEN/ELSE statements. Additionally, a calculation can involve individual cells and absolute amounts (actual numbers included in the formula). The formula can be up to 1024 characters long.
Calculations must be on rows that do not include links to the financial data. However, you can place calculations on consecutive rows, suppress the printing of those rows, and then total the calculation rows for report purposes. The following excerpt of a row definition shows an example of a total that includes a calculation.
R ow Code 
Description 
Format Code 
Related Rates/Rows/Unit 
Print Control 
Link to Financial Data Source 
340 
Cash at Beginning of Period 
NP 
(1100:1110)/BB 

370 
Cash at Beginning of Year 
CAL 
E=C.340 
NP 

400 
Cash at Beginning of Period 
TOT 
340+370 
Given below is the procedure to create a calculation formula:

Doubleclick the Format Code cell in the row definition, and then click CAL.

In the Related Formulas/Rows/Units cell, type the calculation formula.
For information about valid calculation formulas, see the following topics: