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