Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / March 2007

Tip: Looking for answers? Try searching our database.

Averaging a Row of Numbers

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jmedwards2007 - 08 Mar 2007 20:55 GMT
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 - 09 Mar 2007 04:00 GMT
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.
> I'm making a report in which I need to average out a row of numbers equal
> to
[quoted text clipped - 15 lines]
>
> Thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.