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.

I donât think âdefaultâ you added looks right. Youâre adding numbers together, so adding âdefaultâ will break the calculation

Your repeat count does seem correct, that should work as long as the sum is a number in all of the repeat instances

Putting a Display Condition directly on the Repeat node is a bit sketchy. I generally put the display condition on a group inside the repeat, so itâs clear that a repeat exists, but without any relevant quesitons

You can use the Web Apps data preview to see what your calculations are resulting in live in the form. You can also test individual xpath expressions, but be aware that you canât really test the outcome of a calculation with the âEvaluate XPathâ expression if that expression is âinsideâ of a repeat.

Thanks Clayton for the response. You were correct about a repeat count. I have this now, however, it still doesnât update for the by the number (counts)

Iâm confused about what you are trying to compute with the âdefaultâ tags youâre still adding together values with a non-numeric default, which will result in a non-numeric output

I have the default page because of the statement syntax for cond(). I basically want to say that, add 9+ question3 if it is >0, if it is not greater than 0, than I need a "null or "default value. This is because if an answer choice is 0, i need that 0 excluded from the total about to divide by.

Provides the correct calculations when there are no 0 values however, when there are 0 values, the calculations do not run . More screenshots if that helps

I expect that ânullâ will be the output, and that it will be excluded from the demominator ( last screenshot beginning with 9+cond().

Similar to, Sum(1,2, 3), if 3 <0 then exclude 0 value from calculation: effectively, averaging
-> only two numbers. I believe â0â is not the best choice because it will still be an integer that will be calculated to obtain the the denominator score and then the average.

However, I am willing to try anything to get this issue resolved.
Best- Shawn

I believe that removing non-answered questions from the denominator by only adding 1 if the question was answered, and 0 if it was not addresses the concern you are describing.

You wonât be able to get a numeric output from the equations if the math involves non-numeric values.