I am working on a form such that we have different people living in a form of shelter. Let’s say Shelter type A, B, C, D, E, F. These shelters are not all present in all the locations hence, I have a checkbox with a question as thus,
Total number of families in your location
Select the form of shelter in your Location.
If A, C, E and F are selected, a new question for each of the selection will be displayed as thus
How many families are living in A type of Shelter
How many families are living in C type of Shelter
How many families are living in E type of Shelter
How many families are living in F type of Shelter
So here is what I want to do, I want a situation whereby only the ones selected will be cumulated using calculate. Due to the randomness of the responses, I am finding it difficult to achieve.
In the end, I am hoping to compare the cumulative with the Total families living in the location as initially provided.