InfoPath Dev

Hi,

I need to calculate de average of 5 non-repeating fields. My problem is that I need to do this only if the fields have a value on it. I tried sumung all the fields and dividing the result by 5, but the average is not accurrate if one or more of the fileds have no value.

Field:  

a = 10

b = 10

c = 10

d = 10

e = (empty)

Ave= (10 +10 +10 +10 +0) / 5 = 8 :-(

What I want to accomplish is to calculate the average only for the fields that are greater than 1.

Any sugestions?

Try avg((firstField | secondField | thirdField | fourthField | fifthField)[. > 1])

It worked like a swiss clock!

Thanks!!