Running totals in "Interactive Grids"

Scott H.

I've seen many solutions to create a "running total" in a page item for an interactive grid as you add a row, but I really don't like how that looks.

I'd really like it if you could have the "Sum" column automatically recalculate after you enter a row, so you see your total underneath your entered data.  Like how "excel" works

Has anyone figured it out?  Have I missed it anywhere?

Running Apex 19.1 on 12cR2 Std

Thanks,

Scott

Natalie G

How does Excel work? Can you describe it? Is it like a tooltip, or what?

user1.0

I'd like a summary total line at the bottom of my grid.

The sum should automatically calculate a designated column (or columns)

In Excel it VERY basically looks like this:

The Total Cost column is a formula of QTY * EACH COST

Then at the bottom of the "grid" there is a "TOTAL" row with the sum of the numbers in TOTAL COST.

Awais Majeed

https://community.oracle.com/tech/developers/discussion/4306500/running-totals-in-interactive-grids

https://blogs.ontoorsolutions.com/post/2_ways_to_dynamicly_sum_grid_column/

follow this example for running total

user1.0

Thanks Awais.

I've done this before but couldn't find the example to do it again.

I wish there was an easier way to do this. I would think it would be common to want a total row either on the top or bottom of the grid.