The fields within CLASS that allow multi-selection of options affect the way totals and grand totals are counted in DIY reports.
Under Service Details tab, there are some fields that allow the users to select multiple field options. Examples are Problem Type, Assigned To, and Disability Status fields.
Unlike other drop down fields that require the users to select one answer only, these fields allow them to select multiple answers. This mechanism affects DIY reports, which is outlined below.
In DIY report, running the report for 30/11/2018 yields 4 (rather than 3 as above) for No of Service Total. This is because DIY report is counting S175 for both individuals under S175. One can see that S175’s Assigned To field includes both Alice Jones Rabbitt and Victoria Kim. S175 Total indicates that there were two individuals who were assigned this Service.
For obvious reasons, if you are looking to find the total count of service delivered on this day, including Assigned To field in this report will not yield the anticipated result, if there are entries with multiple individuals in the Assigned To field. Therefore, if you are looking for a “true” No of Service Total (delivered in the selected date range), Assigned To field should be removed from this report.
The system logic that affects Assigned To field also affects Problem Types and Disability Status the same way, as seen below. Each Service shows the breakdown of multiple Problem Types or Disability Status types, thus affecting the No of Service Total. As shown above, simply hide No of Service from Drop Data Items Here if you do not wish to see the (misleading) grand total of Services.