Formulas determine what is data is gathered and shown in the value field. The data source can be your product database or other value fields in the current template, and the reference to the data source is made with Template Editor data functions. This is where you use the global attributes listing of your product.
Create a value field before you create a formula.
To create a formula, do the following:
- Select the value field to modify and double-click it to open the Value Field Properties dialog box.
- Click Formula to open the Formula Contents dialog box.
- You can create, modify and check the content of value field formulas in this dialog box. You can select functions and parameters from the lists or type them in the Formula text field.
- Click Check to ensure that the formula syntax is correct. Make corrections if necessary.
- Click OK to save the formula and close the Formula Contents dialog box.
- Set the output properties of the value field to match the outcome of the formula.
- Click OK to accept the changes in the Value Field Properties dialog box.
Note:
If a value field formula consists of a single attribute function, Template Editor automatically sets the Data type, Justify (alignment), Length, Meaning and Unit properties. Depending on the Unit property, Precision or Decimal properties are also set. The values are read from the global attributes definition file.