In this article
Formula are used to perform calculations between two sets of results in the aggregated table; in rows and/or columns. The Formula object is located in the toolbar next to the Statistics and Categories objects .
The mathematical expression used by the Formula can be simple, just a straight addition or subtraction, or it can be relatively complicated and include a number of functions and operators in sequence (go to Expressions for more information).
To use a Formula object, drag it from the toolbar and drop it into the required place in the table. Double-click on the object in the table to open its properties page so you can set it up as required.
Figure 1 - A Formula object being added to a table
When formula objects are used in both the rows and columns of a table, then the calculation order for intersecting cells can be prioritized (go to Priority for more information).
Note: Place the mouse pointer over the formula object in the table to see a text box containing information on the type used, arguments etc. without having to open its Properties sheet.
Note: You can cross a Formula object with a Statistics object, but you cannot cross Statistics with Statistics; if you attempt to do this an error message will be displayed.