A note about totals in the In Detail view

In some cases, when using the In Detail analytics view, the "total" column may not be simply the sum of the other columns.

The reason for this is that if (for example) you select 'gender' as your main report question, and 'incident type' as the secondary one, then the 'total' of the 'man' row is simply the number of reports by men. This may be greater than the sum of all the individual incident types if 'incident type' is optional — since some reports would not appear in any individual column but would still be counted in the total. It can also be less than the sum of all the individual incident types if reporters are allowed to choose multiple incident types — because some reports might appear in more than one column, but only be counted once in the total.

The same logic applies to the "grand total", which is not shown but is used when displaying percentages. This can mean that when percentages are shown, the individual values can add up to more or less than 100%, potentially by quite a lot.

This won't be an issue in every analysis — for example, if you split by reporting form then simply adding up the values will give the correct total, since every report is made through a form and no report is made through multiple forms.