average of summary fields on a layout
I have a summary field on a layout - which is enclosed in a subsummary part. e.g the summary field is called "Summary stakeholder one" - where stakeholder one has given numerical responses to a question.
However I cant seem to calculate the average of this summary value i.e the average score given by stakeholder one to all questions.
There are similar fields for stakeholders two, three and four - for which I also need the averages calculating. I then need to feed these averages into a bar chart. I should be able to generate the bar chart myself - but am jusr giving the whole picture. I just need to know how to compute the averages. thanks