Calculating sum of numeric values in a subform

Calculating sum of numeric values in a subform

Hi,

I'm having difficulties calculating the sum and average of numeric values in a subform. I have a subform named Assessment_Scores and want to average all of the scores in the subform to be viewed on the main form. I've tried using a formula field, however, my expression isn't working.

I tried using

Assessment_Scores.sum(Assessment_Score)

and that didn't work.

Any suggestions?