The server calculates the aggregate values. The aggregates are not updated on the client. So if you make any edits to the IG you will not see the aggregates updated until the changes are saved AND the data is refreshed.
If you need to have a value updated as the IG is being edited take a look at the IG Cookbook app page dynamic column total. Get the cookbook here:
John Snyders-Oracle thanks for the help. Is it possible to show that sum data as a row below interactive grid?
I have given this a little thought and so far have not figure out a way to do that. If I ever do figure it out I will probably put it in the IG cookbook.
Thanks for the update John. My users are happy at least that i'm showing the sum instantly on data change below region. Looking forward for your latest updates on IG cookbook.
Why all that code?! I think there is far easier solution. Correct me if I am wrong, please.
here is the idea,
1- create the page item SumSal.
2- create a GetFocus DA on Sal column to get the existing value in a variable called i.e oldVal.
3- create a OnChange DA on Sal column to set the value of a variable "newVal".
4- :SumSal = :SumSal - oldVal.
5- :sumSal = :SumSal + newVal.
P.s. take care of null values of course. That's a general idea.