Cross Tab totals not adding up
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22457
Printed Date: 19 Apr 2024 at 11:41pm
Topic: Cross Tab totals not adding up
Posted By: Andrewarbogast
Subject: Cross Tab totals not adding up
Date Posted: 20 Sep 2017 at 5:17am
|
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% |
Replies:
Posted By: DBlank
Date Posted: 21 Sep 2017 at 2:36am
| usually it means whatever your distinct count is on exists in more than one group. Therefore it is counted twice (or more) across the groupings but in the summarized grand total it is just counted once. |
Posted By: Andrewarbogast
Date Posted: 21 Sep 2017 at 3:14am
| What if there is no grouping and the cross tab is in the Report Footer? |
Posted By: DBlank
Date Posted: 21 Sep 2017 at 3:21am
|
Maybe I am not understanding your process but "Daily, Weekly, 1 to 3 times per month, etc." is a grouping of sorts.
I assume you are using something like a person identifier as your distinct count. Based on your math process I think that your row count should = your distinct count. If you do a quick summary insert of the Count of that field and the Distinct Count of that field are they the same value? Maybe show some dummy examples of the structure of your data ? |
Posted By: Andrewarbogast
Date Posted: 21 Sep 2017 at 3:45am
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.
|
Posted By: DBlank
Date Posted: 21 Sep 2017 at 6:11am
| what would one client's raw data look like in a table format? |
Posted By: Andrewarbogast
Date Posted: 21 Sep 2017 at 8:04am
|
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. |
Posted By: DBlank
Date Posted: 21 Sep 2017 at 9:05am
|
The CT in a footer (or header) will include everything. Even if it is suppressed. You have to exclude it from the data set to exclude it from the CT.
(NOTE: If you place a CT in a group header or footer it is limited to the data set that falls in that group.) I am not sure you should use distinct count in this instance as the same person has answered it differently at different times. That is more of a question as to how you want to present/analyze your data set. |