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:
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.
- ORA-01461: can bind a LONG value only for insert into a LONG column-Occurs when querying
- difference between "tab" table and all_tables in oracle
- java.sql.SQLException: ORA-00913: Too many values, while trying to insert a double value into Oracle database
- Is Oracle alter table drop constraint drop index syntactically valid?
- Pull data based on state,city,county setup
- How to find number of Sundays in a given year (ex: input_year = 1996) and also the dates of those Sundays
- Oracle search text of views
- Oracle Table transpose
- Get the list of records to delete based on a column and list of tables
- Oracle Database: Find Missing Indexes for Performance tuning
- Using pivot on multiple columns of an Oracle row
- Filtering duplicate values, searching for pairs
- Oracle find tablename given an index name
- Query runs quickly in Oracle SQL Developer, but slowly in SSRS 2008 R2
- Display names of all constraints for a table in Oracle SQL
- Case causing ORA-01790: expression must have same datatype as corresponding expression error
- Update avg value in table
- Oracle case on REGEXP_LIKE return false instead true
- How to get SUBSTR of an LPAD of a number in ORACLE?
- How to remove the slash and get output as mentioned from the date in oracle apex sql
- Oracle Strange Index Behavior?
- Identifier must be declared ORA-06550 and PLS-00201
- BETWEEN clause versus <= AND >=
- How to solve : SQL Error: ORA-00604: error occurred at recursive SQL level 1
- Reading Oracle boolean filed dbms_utility.is_cluster_database in statement
- How to write a condition to do something where a for loop returns no rows
- Detect all special characters (ascii codes 128 to 255) on a varchar column
- Invalid Identifier error while using standard_hash function in oracle 11g
- Modify a column to NULL - Oracle
- Oracle Connection in C# - connection string