Creating and Using Report Tables
Linking Report Variables

To generate user-defined report variables, use the four basic arithmetic operations or powers to link two or more report variables. Link the single variables, using the formulas of the Report Categories.

To link two report variables

  1. Select a report column, and then select Add Column on the Table menu.

  2. In the Formula field of the Add Report Column dialog box, enter the formulas you wish to link by mathematical operators. You can copy the syntax by selecting the required formula and pressing the CTRL+C. Change to the edit box again and insert the formula by pressing CTRL+V.

    Note that the variable names are not identical with their "formulas"; for example, peak height and peak.height). For the correct syntax, refer to Report Categories.

    Example: To put the peak height in relation to the corresponding Amount, use the following expression:

    peak.height / peak.amount

    You can also use the following operators to link expressions: +, -, x, and ^ (for powers)

  3. Enter a column header in the Header field.

  4. Click OK.

 

 Tip:

Mathematical and statistical functions such as SUM, AVERAGE, etc. are only available in the Report and in the Printer Layout together with the Report Publisher!