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 Layout Editor, 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 Property Sheet, select the ‘Initialize display text’ event.

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

= (Quantity * UnitPrice) – Discount

Step 5:  Build and run your application.

See Also

Common Formula Examples