Avg / eval in infopath

S

Shannon

I’m trying to average multiple fields InfoPath and I keep getting an error.
Structure:
Coworker (type “groupâ€)
Under the folder I have 17 drop down boxes that I would like to average
together
…. Formula tried,
Avg(eval(coworker,â€F7 * F23))
Avg(eval(coworker,â€F7 : F23))

Currently using…..(this one works, but its long and would be hard to maintain.
(sum(F7) + ((F8)) + ((F9)) + ((F10)) + ((F11)) + ((F12)) + ((F13)) + ((F14))
+ ((F15)) + ((F16)) + ((F17)) + ((F18)) + ((F19)) + ((F20)) + ((F21)) +
((F22)) + ((F23))) / 17
 
S

Swathi (GGK Tech)

Hi,
Use the following expression.
xdMath:Avg(<xpath of the group>/*)
ex: xdMath:Avg(../my:group3/*)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top