You can display the largest numeric field value from a table column in any label, literal, textbox or dropdown list control using the MAX function. For example, the maximum among the “Quantity” values displayed on a ShowOrder_DetailsTable page can be displayed for the “Initialize When Displaying” event.
Step 1: In the Page Layout Spreadsheet, select a table control and navigate to the table rows section.
Step 2: Drag a literal control from the Toolbox into the newly added column within the ‘Totals’ 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, e.g.:
= Order_DetailsTableControl.MAX("Quantity")
Step 5: Build and run your application.