Hi,
Is have been able to sum repeated question.
However, I have an unresolved issue, I have 7 repeated integer questions, that I need to sum in order to estimate the mean. I used the count function so I can then estimate the mean = total sum / total count answer question.
The problem is that not always the 7 repeated questions will have a response, so that value will be NA or 0. I try to use coalesce to solve this issue, but is not working.
I don't want the 0 value counted in the count function towards estimating the mean.
I have try to get around this issue.
Example:
coalesce(sum(${producto_1.1.1})+sum(${producto_1.1.2})+sum(${producto_1.1.3}),0)....
or
sum(coalesce(${producto_1.1.1},0))+sum(coalesce(${producto_1.1.2},0)).....
I'm attaching the XLSForm
@DougBrowning @IsmaelChivite
Cheers,
Federico