You can display the smallest numeric field value from a table column in any label, literal, textbox or dropdown list control using the MIN function. For example, the minimum 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.MIN("Quantity")
Step 5: Build and run your application.