I have a questionnaire where I'm getting an average value of the numerical values of the answers that have been selected.
All the questions have an answer option of "Not Applicable", I have assigned a numerical value of zero to this answer option.
The trouble is, if one of these answers has been selected, it is impacting the AVERAGE calculation. Although the value doesn't make any difference to the total that is being divided, it is still a question that has been answered & is therefore included in the divisor.
For example, if there are three selected answers, all with a numerical value of 2, the total is 6, divided by the number of questions, so the average is 2.
If however one of the answers has a numerical value of 0, the total is 4, but this is still divided by the number of questions, so the average is 1.33. I would like the 0 value answer to be excluded from the calculation, so that the average would 2.
Lovely job, cheers Scott, did the trick.
The only slightly annoying thing is that it isn't possible to "unassign" a numerical value. I had to delete the values list item & then create a new one & by default, it did not have a numerical value assigned.
I can't reproduce this behavior. If I go to a values list value and change it's numeric from blank to 10, then save the value and save the values list, when I go back to the list that value has a numeric of 10 as I'd expect. If I then delete the 10, and again save the value and then save the values list, when I go back to the list that value has a numeric of blank.
As my avatar would say "D'oh!"
It didn't even cross my mind just to delete the numerical value
I've been putting calculations & DDEs together all day & the simplest of things didn't even occur to me.
Curiously, while it is possible to delete the numerical value by accessing the answers values list directly from the questionnaire through Application Builder, if you come at it from the Question Library, the value is a required field. When viewing the answer value from the Question Library, the answer has a value of 0, whereas directly in the values list, it does not have a value.
Perhaps I need to call time on the week & get the weekend started.
Thanks again Scott.