Display Row Rank in a Table Control

You can use a formula to display a table row rank in a table control.

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 rank:

= OrdersTableControlRow.RANK(“Freight”)

Step 5:  Build and run your application.

Note: The column value used for the rank should be a numeric value.

See Also

Common Formula Examples