CODEWITHSUNDEEP
oracle11goracle10goracle-apexoracle-apex-5.1oracle-apex-5
Abinnaya
Abinnaya

Reputation: 223

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

Upvotes: 0

Views: 4748

Answers (1)

Littlefoot
Littlefoot

Reputation: 142705

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.

  • Event: Save [Interactive Grid]
  • Selection Type: Region
  • Region: put region name here, e.g. "IG emp" or whatever that region is named on your page

True action will then be:

  • Action: Refresh
  • Selection type: Region
  • Region: as above ("IG emp")

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

Upvotes: 1

Related Questions