Tuesday, December 10, 2013

InfoPath 2010: Calculate AVG and COUNT on multiple fields

A couple more calculations for InfoPath 2010:

To get the average of multiple Number fields, including a repeating table Number field, use the following:



Likewise, to get the total count of multiple fields that contain data, including a repeating table field, use the following:



More calculations will be posted as I deem necessary.
Posted by at

6 comments:

  1. AnonymousJanuary 15, 2014 at 5:43 AM

    Thanks a lot. This is what I was looking for!

    ReplyDelete
  2. BonsterAugust 25, 2015 at 12:43 PM

    How do I recreate the dividers between the fields? I haven't yet figured out an 'acceptable' way to do this in InfoPath.

    Thanks

    ReplyDelete
  3. PatrickNovember 6, 2015 at 11:52 AM

    Pipes of course. Thanks

    ReplyDelete
  4. UnknownDecember 13, 2015 at 7:43 PM

    Buddy you are the gratest. THANKS!

    ReplyDelete
  5. PrashantNovember 20, 2016 at 12:47 AM

    how we can calculate the average of values like;
    field 1 = 34:21:52 & field2 = 14:25:18

    ReplyDelete
  6. AnonymousApril 6, 2017 at 11:56 AM

    I am getting an error that the field I have the avg in, the final result is not an integer

    ReplyDelete

Subscribe to: Post Comments (Atom)