I need to average 11 questions and exclude 2 questions if they = 0 from the total average. i.e. from the numerator and denominator in div to perform average.
Will the above execute, so that if domain 3 or if domain 4 =0 then they are excluded from the calculation? I attempted to achieve this by creating a repeat group to repeat the count () of the sum hidden value.
Finally, I attempted to use my repeat group (that should count the number of items to sum) as the denominator for the calculation.
Will this accurately, provide me the average of 11 items excluding those that are zeros?
Bonus points: Where can I check the result of my calculations? Other than running it in web apps i have no clue if it is calculating correctly, or what the final scores are.
Thanks to those willing to help out.