Hi, grateful for all assistance I receive. I have a question in a repeat group which will ask each member to indicate all the disabilities that apply to each of them. This can result in zero selected, one selected or multiple selected. In the case of a single disability selected i would like the value of 1 scored. In the case of multiple disabilities selected I would like the value of 2 scored.
Can you revise the attached xls sheet (rows 85-89 highlighted) and tell me whether this expression has been written correctly. Note i also want a value of zero assigned if none is selected.
Also given that this count is to be calculated based on each additional household member, am I missing another calculation. And what calculation will be added to Tier 1 (row 166) to obtain a cummulative score ?Disability Count.xlsx (24.7 KB)