Formulas process the database references that are stored in the list. Before you start building a formula, make sure to define the goal or intended use of the list and formula very clearly. It is best to draw up a sketch in advance.
- Add a new formula to a list.
- Enter a unique and speaking name in the Header column.
- Double-click to open the new formula.
- Specify the result data type of the formula. This determines whether the result will be shown as
a) Picture (Picture)
b) Date (Date)
c) Text (String)
d) Time (Time)
e) Boolean value (Truth value -> true, false)
f) Number (longint-> integer; real -> number with decimal separator)
. - Enter the formula in the input field (see formula catalogue) or use one of the ready-made functions (right).
- Insert the list fields 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 conversion. The result, i.e. the expected data type, must match the result type of the formula.
Example Convert number to text:
String([Count (number)];"###.##0,00")
Converts the result of the "Number" field into the result type Text. A format mask can be specified using the second parameter (here e.g. 2,500.00) - Select Apply to single data rows from the dropdown box below the input window for lists that are processed statistically. This means the formula takes effect before summarising.
- Check the formula.
