Can this be done? I have a survey, which the scores are 100 through 10, and if n/a applies it assigns a 0 value. I wish I would have thought of this earlier, now I want to perform an average with out the 0 value.
For example on the report footer it reads, =Avg([Helpfulness]).
I used option values, therefore I'm stuck with storing a number in the table.
Help would be greatly appreciated.
For example on the report footer it reads, =Avg([Helpfulness]).
I used option values, therefore I'm stuck with storing a number in the table.
Help would be greatly appreciated.
