I work at a medical facility. I am on Crystal 8.5. I have two cross tabs. One that counts visits which has worked fine. The other takes those visits and turns them into percentages. For example:
Row: admission source: Emergency Room. Column: Hospital Name. Summarized field: Should reflect 80.22%. (Emergency Room had 215 patients. TOTAL patients for all admission sources was 268. 215/268=80.22%.) I am having trouble coming up with a formula to derive the percentages for summarized fields. I have tried:{visits/Sum({visits}) but it does not like it. I have also tried some other things. Can you help me? Thank you.
Row: admission source: Emergency Room. Column: Hospital Name. Summarized field: Should reflect 80.22%. (Emergency Room had 215 patients. TOTAL patients for all admission sources was 268. 215/268=80.22%.) I am having trouble coming up with a formula to derive the percentages for summarized fields. I have tried:{visits/Sum({visits}) but it does not like it. I have also tried some other things. Can you help me? Thank you.