Checking for Consistency between two Summation

[Sham_me]

Hi Family,
I have run a code to validate a calculated field in row14 against sum entries in row 15, such that the figure the enumerator will enter in Row15 should not be more the calculated individual sum in Row14.

Kindly assist me.

Thank you.

The xls below
Summation_issues.xlsx (12.1 KB)

[Kal_Lam]

@Sham_me, use the coalesce as outlined in this post discussed previously and that should solve your issue:

Calculating the sum

You could do the same as outlined in the image shared below: In the survey tab of your xlsform: [Image 1] Data entry screen as seen in Enketo: [Image 2] Reference xlsform: Sum.xlsx (8.9 KB)