Skip to main content

Merging Issues - sampled (X/Y) and percentage (X%)

Merging combines answers by adding sample counts together or averaging percentages, depending on results entered.

DIO avatar
Written by DIO
Updated over 3 weeks ago

Scenario:

In a team audit, two auditors completed assessments on the same question at the same site, but entered their results differently:

  • Auditor A entered a sample (e.g. "2/3", which equates to about 66%)

  • Auditor B entered only the percentage (e.g. "20%) , omitting sample values

As a result, the system shows a warning due to conflicting input formats.

The system provides the following warning:

How the System Merges the inputs

The merge logic only applies when both auditors answered the same question at the same site.

  1. If both auditors provide a sample (X/Y):

    The system sums both the numerators and denominators, then recomputes the percentage.

    • Example: 3/15 (20%) + 2/3 (66%)

  2. If both auditors provided a percentage (X%):

    The system averages the two percentages directly.

    • Example: 20% and 66% -> (20% + 66%) / 2 = 43%

  3. If one auditor uses sample (X/Y) and the other uses percentage (X%):

    Because the system cannot deduce how the percentage was obtained (e.g. 20% might come from 1/5, 20/100 etc.), it discards the sample data altogether and averages the percentages only.

    • Example: 20% and 66% -> (20% + 66%) / 2 = 43%

Did this answer your question?