Hello Team, I wanted to validate a total value in Kobo form builder. For example, I have total hospital admissions which should be equal to sum of hospital admission sub categories listed by causes of admission. I tried to put in a validation which should flag an error when the sum of the categories becomes greater than the recorded total. However, the validation doesn’t seem to work in the preview. I would appreciate your support on this.
Welcome to the community, @bizaheran! Could you share with the community your dummy questions so that the community would be able to have a look at it?
Thank you @Kal_Lam. I highlighted the questions in the attached form. Eg. the sum of admissions from sub categories(rows 11-18) should be equal to the total number of admissions recorded(row 8). I wanted to add validation that flags error when the data in the sub categories is greater than total. SLL_Form.xlsx (12.3 KB)
@bizaheran, you could do it as outlined in the image shared below:
In the survey tab of your xlsform:
Data entry screen as seen in Enekto: when the number tries to exceed
Data entry screen as seen in Enekto: when the number matches
SLL_Form.xlsx (14.6 KB)
Perfect! Thank you so much for your prompt support.