Formulas process the database references that are stored in the list. Before you start with the formula, the goal or the desired result of the list and formula must be clearly defined. It is best to create a sketch in advance.
- Add a new formula to the corresponding list.
- Enter a clear and descriptive name in the Heading column.
- Double-click to open the new formula.
- Specify the result data type of the formula. This determines whether the result is displayed as
a) Picture (Picture)
b) Date (Date)
c) Text (string)
d) Time (Time)
e) Truth value (Boolean - > true, false)
f) Number (longint- > integer; real - > number with decimal separator)
is issued.
- Enter the formula in the input field (see formula catalogue) or use one of the ready-made functions (right).
- Insert the fields from the list that are used as formula operators into the formula.
Note: The fields must be identical to the result data type or converted to the same format using functions (e.g. string). Text and number cannot be combined in a formula without harmonisation. The result, i.e. the expected data type, must match the result type of the formula.
Example Convert number to text:
String([number (number)];"###.##0,00")
Converts the result of the "Number" field into the result type Text. The desired format mask can be specified with the second parameter (here e.g. 2,500.00)
- Select Apply results of individual fields from the dropdown box for lists that are processed statistically so that the formula with the contained references takes effect before the summary.
- Check the formula.
