In TX Text Control X16, Excel compatible formulas can be used in table cells to calculate results based on values and references to other cells in the same table. More than 100 different formulas are supported and can be combined.
The following screenshot shows a list of invoice items created with MailMerge:
The data for this example is a very simple XML:
In the above XML source, you can see that only 4 data points are available:
The other columns in the table are calculated based on these values.
The following screenshot shows the formula of the Line Total column in the ribbon UI. The value is calculated based on quantity multiplied the unit price minus discount.
The Total value is calculated with the following formula that creates a sum of all numeric rows above in the same column:
Additionally, two values are calculated based on the existing data in the table.
- Average discount:
- Number of items:
In this sample template, another new feature of MailMerge is used: Sorting. The complete list is sorted by unit price:
This sample shows the power of MailMerge in combination with Microsoft Excel compatible formulas. The major advantage of using formulas is that data, that could be calculated, must not be stored in your data source or must not be calculated in your business object. TX Text Control is doing this for you when the data is required.
Another great idea of TX Text Control X16 - stay tuned for more.