Display Row Totals in a Table Control

You can use a formula to display a table row total in a table control.  This can be useful when calculating the final price after addition of additional charges or sales tax.

Step 1:  In the Page Layout Spreadsheet, select a table control and navigate to the table rows section.

Step 2:  Insert a column into the layout and drag a literal control from the Toolbox into the newly added column within the ‘Table row’ area (the repeating row area).

Step 3:  Select the newly added literal control, and in the Formulas tab, select the ‘Initialize when Displaying’ event.

Step 4:  Enter a formula to display the row total:

= UnitPrice + AdditionalCharges

Step 5:  Build and run your application.

See Also

Common Formula Examples