InfoPath Dev

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!

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'])

Perfect - worked perfectly!

 Thanks so much!