averages

[pmusaev]

hello there, i need some help doing the following:

i have setup a progress dB with data being collected by means of radio buttons. eg.

Level of trust 00000 (radio buttons with levels 1-5)

Performed Well 00000

etc..

each radio button in each row is given the same field name (eg. "a1" for row 1, and "a2" for row 2). i create multiple records for the same person and would like a summary of the averages a person rates for each entry. could i get some help, or if more clarification is needed, please ask. thank you all so very much.

[pmusaev]

more information by me:

One database per person. Each record in this dB is a different project the person has worked on, so each record will have different ratings for the same testing areas. What I need is to display a summary of all the testing areas with an average rating, calculated from all the individual projects.

Right now I have the following setup:

Level ratings are from 1-5. Each testing area is given a unique field name (

[pmusaev]

What I need to do is have a summary page that displays the average rating for the particular person for each testing area.

[pmusaev]

what i'm going with... having a separate file for summary, now i need a calculation that will count up all the values for "a1" etc... and then divide it by how many records there is. ... please help!

[jamesooooo]

OK, If i understand this right each person will have his or her own db which will have a record for each project he or she does and it will have 5 fields in it call a1,a2,a3,a4,a5 and each of those will have a value between 1 to 5 right? and you want to total up those ( a1-a5 ) for all the records and then get that devided by the number of records?

[Riley Waugh]

See my answer to your post in "level indicator"

[pmusaev]

james --

correct, i have used the Summarized field type and chose "Average of" so far so good... any suggestions?

cheers