The Calculation Template Lines are built similarly to a spreadsheet. When you have entered Types, Calculation Types and Descriptions into the Calculation Template Lines, the columns (up to 10) and lines of the template will form a matrix of cells in which you can create your formulas. You can make a look-up from each cell to open the Calculation Formulas.
When a cell contains formulas, it will display the first Formula Line including both Expression and Condition, provided that Show in Cells is set to Calculation Formulas. The Condition will be marked <condition> and in case of more than one Formula Line, the message <more formula lines> will also appear.
From each Calculation Template Line of the Type Calculation it is possible to open
the Calculation Property window where you can set different properties for the cells.
The Description fields are automatically shown in bold if the Type of the line is Text.
If the Type is Calculation, you can look up the list of Calculation Types where you
can set up the line to be shown in bold.
When you work with the Calculation Formulas, the Show in Cells field must be set to Calculation
Formulas but you can also have either the Get Value Formulas or the Overview Columns shown in the
cells.
If you select Get Value Formulas, you will see or you can create/modify the formulas that fill default values into new
Calculations created on the basis of this Calculation Template.
If you set Show in Cells to Overview Columns, the cells will show column references to the Calculation Overview
specified in the Calculation Overview Setup field and you can also create new or edit existing column references here. The references
are shown as Column No. and Column Name from the Calculation Overview.