Define this in a calculation field in table 1: Average ( Table 2::GPA )
Thanks PhilModJunk for your quick reply,
I tried that already. But, Its not working.
Let me give you more details:
- I have layout for Table1. In which I have portal tool for adding Table 2 values.
- After I add values for Subj1, Subj2, Subj3 in portal Tool my GPA in Portal Tool is automatically updated
- But, It is not updating my Cum GPA, from Table2.
It should update automatically as you update each field in the portal.
Compare your solution with this generalized demo file: http://www.4shared.com/file/tgUOB8Aa/AverageOfAverage.html
cAvgAvg is the name of the field in this demo that's computing the cumulative average.
I was using Number datatype for "Cum GPA" and using "Calculation" under "Option > Auto Enter". Thats why it was not working.
Now it is working like a charm :-)