Form/label designer data field
At the Designer screen:-
● Select: Tools - Data
or
Select
the option on the Object Toolbar
The program displays a dialog showing a list of Data objects, select the Calculated field item from the add Data dialog.
Once selected, the Calculated field dialog is used to enter the details for either a simple text field or a calculated field.
For text fields the only control available is the text control and this is where the required text is entered.
dialog is as follows:
Calculated fields
The text field is the name that will appear in the designer, the calculation edit box is where the formula is entered. The button on the right is used to select fields to appear in the formula.
The Decimal places is used to specify the number of decimal places that will appear for the answer in the form/label design output.
The Total as: can be either Sum or Average, this applies to sub-totals or grand-totals.
If Sum is selected then all the previous answers will be added together, whereas Average adds all the previous answers together and divides by the number of items.
The formula can be either numeric or string based.
e.g.
Part list form - calculation of part area in m2
=(Length - millimetres*Width - millimetres)/1000
Part list form - output first 3 characters of the material used for each part
=STR(LEFT(Material code,3))
