oracle11goracle10goracle-apexoracle-apex-5.1oracle-apex-5

get total sum of Interactive Grid Column Oracle APEX


I have one interactive grid and i want to sum the amount at bottom, i have created aggregate on report but the values are not changing in the interactive grid, how to get total sum of Interactive Grid Amount Column values


Solution

  • You don't have to do anything special; using the Actions menu, go to Data and then Aggregate. Choose column you want to sum and - that's it:

    enter image description here


    Aha; as you commented, you want to refresh that value once you change something in the grid.

    You could create a dynamic action on the Interactive Grid region.

    True action will then be:

    That's it - run the page, change some value, push the "Save" button - the total value should now change.