You are viewing limited content. For full access, please sign in.

Question

Question

Calculating Average for Multiple Rows in Table

asked on November 16, 2016

System: Forms 10.1

 

I have a table (see attached). I want to calculate the average on each row. Any help would be greatly appreciated.

Form Help.PNG
Form Help.PNG (13.32 KB)
0 0

Replies

replied on November 16, 2016

Hey Doug,

 

There is a function section under the field options advanced tab.

=AVERAGE(Avg_table.c1,Avg_table.c2,Avg_table.c3)  should be it. You can use the ">" to select the correct fields you want to average.  They'll be found under the table name.

 

Hope this helps.

Capture1.PNG
Capture1.PNG (25.18 KB)
1 0
replied on November 16, 2016 Show version history

If you want to calculate the average of the C1 through C6 columns on a per row basis, then use this formula in the Avg column. Note that this assumes your table uses the variable "Table" and the C1 to C6 columns use the variables C1, C2, etc.

=AVG(INDEX(Table.C1,ROW()),INDEX(Table.C2,ROW()),INDEX(Table.C3,ROW()),INDEX(Table.C4,ROW()),INDEX(Table.C5,ROW()),INDEX(Table.C6,ROW()))

This results in the Avg column only calculating the average value in that row. As a side note, because the C1 to C6 columns are all required, I might suggest setting 0 as a default value in those columns.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.