Calculate Member of Household Rooster Value with Source from Repeat and Non-repeat Question

Dear Colleagues,

I would like to formulate a Calculation to generate one outcome variable that applies to the children in the Household Rooster (Repeated Group). The problem is that the source of the composite questions are not only in repeated group (HH rooster) but also from the household level (not in repeat group). So how can I generate one variable, namely ‘Vulnerability’, for each child in the member household rooster. I am expecting that the result of the output data is in the form of separate data (children data) from household level data.

I enclosed the developed xls form and below is the formulation:
"Factor A: if pbr02=2 OR hdi09=0 OR hdi11=2
Factor B: if ((hdi10_1=1 OR hdi10_2=1 OR hdi10_3=1 OR hdi10_4=1 OR hdi10_5=1 OR hdi10_6=1) OR hed01=1
Factor C: if hed03a=0 OR hcd03b=12 OR hed03c=0 OR hcd01=1 OR hcd02=1
Vulnerable Children: if children experience at least 2 FACTOR
CAREGIVER_BASELINE_vulnerability.xlsx (29.5 KB)

Thanks for all kind support!
Best Regards,

Hi @Kal_Lam , would you mind to share your helpful thoughts on my issue? Thanks in advance

Will have a look at it and get back to you. But our community should also have some workarounds if anyone has already worked on a similar issue like this before.

Thanks @Kal_Lam for your respond. I have searched around similar this issue, but still not get the answer. I don’t know whether it’s about index repear Or using “jr…”

Thanks

Thanks a lot.

1 Like

Thanks @Kal_Lam. However, I have searched around same issue, but still could not find the perfect answer. I don’t know whether it’s about index repeat Or using “jr…”

Thanks

Will have a look at it and get back to you. But our community should also have some workarounds if anyone has already worked on a similar issue like this before. :slight_smile:

Thanks @Kal_Lam for your respond. I have searched around similar this issue, but still not get the answer. I don’t know whether it’s about index repeat Or using “jr…” :smiling_face_with_three_hearts:

Hello, Thanks @Kal_Lam for your respond. I have searched around similar this issue, but still not get the answer. I don’t know whether it’s about index repeat Or using “jr…”

Hello

Thanks @Kal_Lam for your reply.

1 Like

Hello
Much thanks to you for your input. Will view it and hit you up. In any case, our local area ought to likewise have some workarounds on the off chance that anybody has previously taken care of on a comparable problem like this previously.
Much obliged @Kal_Lam for your answer. I have looked through around comparative this issue, yet not find the solution. I don’t realize whether it’s about record repear Or utilizing "jr… "
Regard:
condos for sale in downtown toronto

Dears,
I found a solution to the problem at hand

Best,
CAREGIVER_BASELINE_vulnerability.xlsx (30.2 KB)

1 Like

@MohammedTaleb, :clap: :heart: :partying_face:

1 Like

Hi @MohammedTaleb . Superb! Thank you

2 Likes

Hi
Much gratitude to you for your feedback. Will see it and hit you up. Regardless, our neighborhood to in like manner have some workarounds if anyone has recently dealt with on a similar issue like this beforehand.
Thankful @Kal_Lam for your response. I have glanced through around relative this issue, yet not track down the arrangement.