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.
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.
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.