Formulas in lists and reports access database references and added fields in the list and can be further processed with the help of functions. Explanations of functions and formulas can be found in the manual under Formula catalogue or in the application under  Configurations >  Catalogues >  Formula catalogue.

1. Click on  Add formula to insert a formula.
2. Enter a unique name for the formula in the column Header .
3. Double-click to open the new formula and enter the resulting data type (e.g. number, text, Boolean value).
   Note: Fields and result must be of the same data type or converted using "string".
4. Select a Function from the column on the right or enter the formula manually in the input field.
   Note: On selecting a function, a detailed description will appear in the Field and function details.
5. To insert the fields at a suitable location, select the location of the function/formula and double-click the Field .
6. Check your formula.
7. Confirm your input by clicking OK .