Calculations in the text

<< Click to Display Table of Contents >>

Calculations in the text

TextMaker enables you to easily perform calculations in your documents:

You can insert calculations directly into the text; the results are displayed and printed.

Variables can also be used in calculations. In this way, you can determine intermediate results and calculate with them.

You can use both database fields and the contents of objects in calculations. Table1.A1, for example, returns the contents of cell A1 in table "Table1".

You can easily enter the formula via the dialog box of the ribbon command Insert | group Text | Field dropdown_arrow | Calculation. This dialog box also contains lists of all variables, database fields, functions and operators.

The calculation functionality is especially useful due to the fact that it allows the contents of database fields to be included in the calculations. Do you want to create invoices? No problem: If your invoice database has fields for quantity and price, you can have TextMaker perform calculations like QUANTITY * PRICE in order to create and print invoices as a mail merge.

You can also perform calculations with the contents of objects. For example, the formula "Textbox1.Value * 2" reads the numeric value in the text field named "Textbox1" and multiplies it by two.

The following pages contain detailed information on calculations. The information covers the following topics:

Inserting calculations

Formatting and rounding calculations

Updating calculations

Conditional text

Simple calculations at the touch of a button

Formulas and functions