on 06-23-2016 11:01 PM
I have a data set that has patients who have their main Doctor. We are doing a count per Doctor ( of patients); but also we include their classification;
if they are considered sick or regular.
Within sick we have 3 types. Let's just call it A, B, or C.
The thing is, some patients have diagnosis for all 3 as well as regular; many have 2 + regular, and 1 + regular.
So we don't want to count the patient 4 times but only once. We would want for example, if they have A as well as others, the patient would be Diag/ A
if B, B etc. and then only show them one time with the 'A' or 'B' etc.
How do I make such a formula to decide how to show only one row?
Hi Paul,
1) Insert a group on the Patient field.
2) Create a formula with this code to sort the diagnosis:
If {diagnosis} = 'A' then 1
else If {diagnosis} = 'B' then 2
else 3
3) Add this formula field to the 'Record Sort Expert' below the Patient Group.
4) Move all fields from the Details Section to the Group Header/Footer of the Patient Group.
5) Expand Field Explorer > Running Total fields > New.
Use the Patient Field as the Field to Summarize > Use 'Distinct count' as the summary operation > Set the Reset to what group is above the Patient Group.
6) Drag and drop the Running Total on the Group Footer that is below the Patient Group.
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.