Newbie Questions

Re: Calculating the avg of radio buttons, where one option is NA

saj322 — Thu, 06 Nov 2008 18:02:30 GMT

Perfect - worked perfectly!

Thanks so much!

Re: Calculating the avg of radio buttons, where one option is NA

Anuma — Thu, 06 Nov 2008 17:51:24 GMT

Hi,

Try this

xdMath:Avg(../my:field106[.!='N/A'] | ../my:field107[.!='N/A'] | ../my:field108[.!='N/A'] | ../my:field109[.!='N/A'] | ../my:field110[.!='N/A'])

Calculating the avg of radio buttons, where one option is NA

saj322 — Thu, 06 Nov 2008 17:05:42 GMT

I created a form that has multiple tables made up of radio buttons. For 2 of my tables "N/A" is an option. How do i write a formula for these tables, so that when the user picks "N/A", that value does not get counted and included in the avg function? I am using this as my formula:

xdMath:Avg(../my:field106 | ../my:field107 | ../my:field108 | ../my:field109 | ../my:field110)

For one table, all fields have an N/A radio button option. And for the other table, only one field has an N/A option button.

Thanks!