So a coworker and I are reporting out Assessment Reviews using a cross tab. We have the field that contain the questions and then in summarized fields we have a distinct count and Percentage of Distinct Count. What we noticed is when you add the percentages and totals, it doesn't equal the grand totals and the percentages are over 100%. Any idea on what could be causing this? Thanks so much.

     Total
Total     1,818
     100.00%

1-3 times 286
a month     15.73%
     
Daily     880
     48.40%

Less than one 126
time a month 6.93%     
     
No recent 25
contact      1.38%
     
Not interfering     156
     8.58%

Weekly     370
     20.35%

What if there is no grouping and the cross tab is in the Report Footer?

Here's my cross tab expert. This cross tab is in my Report Footer. The field in my row contains the various answers available and then for the summarized field I wanted totals for each answer. The summarized field is the client identifier.




Edited by Andrewarbogast - 21 Sep 2017 at 3:50am

CLIENT      Date    howfrequently question
25          5/2/17        Daily


The question the field contains is: How Frequently does your mental health interfere with your life and they can answer not interfering, daily, 1-3 months, weekly, not interfering.


What I'm noticing when I put these fields in details that a client could receive multiple reviews in my date range. So I'm not sure if by putting the cross tab in the footer if it's including these multiple reviews.

Edited by Andrewarbogast - 21 Sep 2017 at 8:06am