To calculate the sum of values in a selected row of an interactive grid in Oracle Apex, you can follow these steps:
var grid = apex.region("interactive_grid_region_id").widget().interactiveGrid("getViews", "grid"); // Replace "interactive_grid_region_id" with the ID of your interactive grid region. var selectedRowData = grid.getSelectedRecords()[0]; // Get the data of the selected row. var totalSum = 0; Object.keys(selectedRowData).forEach(function(columnName) { var columnValue = selectedRowData[columnName]; if (!isNaN(columnValue)) { // Check if the value is a number. totalSum += parseFloat(columnValue); } }); alert("Total sum: " + totalSum); // Display the total sum in an alert box.
Asked: 2023-07-09 07:45:25 +0000
Seen: 12 times
Last updated: Jul 09 '23