Averaging a Row of Numbers

[jmedwards2007]

I'm making a report in which I need to average out a row of numbers equal to
the number of weeks in the year. I've inserted a repeating table in which to
put my weekly averages. But what I need to do now is to insert an Expression
box in my Year To Date column to average up all my weekly totals which will
be in the repeating table to the right of my form. I need a little help with
the formula on getting to average from the embedded table to my YTD column I
tried using the formula (sum(my:group1/my:group2)) div
(count(my:group1/my:group2)) but it doesn't seem to work just wondering if
someone could help me out and let me know what I'm doing wrong or what I need
to do.

Thanks

 

[Zhang Haiguang]

Maybe you could use "xdMath:Avg(my:group1/my:group2/my:field1)".
The average calculation should be executed on a field, rather then a group,
ok?

http://www.infojetsoft.com
InfoJet Service, an InfoPath Web form product.