Included with WPReporter is a formula parser. It has been optimized to work with currency values. So you can add calculation to your text and tables. The calculation feature has been optimized for business needs, i.e. sum values and apply VAT. It uses numbers which are displayed (rounded to 2 decimals) not using internal exact values which would lead to incorrect results.
The calculation feature uses cell/paragraph names and formulas. The names can be used in the formulas an are replaced by the sum of the values which use this name.
This feature can also be combined with the fetaure to repeat table header and footer rows. This makes it possible to display a subtotal at the end of the page and at the start of the next page. There are API functions to sum um values from paragraphs or mail merge fields located on one page or in the current column.
Details about the formulas
The easiest way to sum up a column is to assign a certain name to each cell in this column. Use the same name as formula of the cell which should display the total. It is also possible to display results in field objects, so you can embed it in the text. But WPTools also supports formulas to read out neighbour cells: "left(1)" will return the value of the first cell to the left - so formulas can stay valid when rows are inserted.
The optional display of the cell names (red) and cell formulas (blue) was switched on for this screen shot.
