Comparison table

What is the problem? Please be detailed.
Am trying to figure out how to put attached table into odk form.
The table have two section to be filled

  1. From paper
  2. EMR
    Am supposed to compare both dates for EMR and Paper, if both dates match an output of 1 is given as results but if not match zero is give as a result. Then at the end a total percentage is calculated out of the 30 sampled files

What ODK tool and version are you using? And on what device and operating system version?
version 1.18.2
What steps can we take to reproduce the problem?
Have tried but managed to capture five files but files to be sampled are 30. Is there an easy way to do than the one i have used

Attached is both xlsx and question Consistency_Calculation.xlsx (11.0 KB)
EMR data completeness comparison.docx (23.1 KB)

Just to be clear, is the problem that your provided form doesn't work, or it does work and you just want to know whether there is a easier way to scale it to 30 sample pairs?

If the latter, you could use a repeat group with a count=30, and use sum() to tally the results of each date comparison to generate your overall totals. See Counting the number of times a particular answer was given.

1 Like