Tutorial: Invoice with total sum of all invoice positions

Hey there,

recently, somebody asked me if it is possible to create an invoice with the page design plugin AND to print the total sum of all positions on the invoice. Here is what it should look like. This is a tutorial how to get the 210 € on the invoice.

To get this result, it is necessary to use the right base design. The page designer can only use one row and is incapable to calculate something. Therefore, the calculations have to be done upfront.

Here is the base design I would recommend:

The most important column is the link formula with rollup:

Of course this example is very limited. Usually, the products should be stored in another table etc… But I hope you get the idea.