Counting Subsummary Occurrences

[CLL7]

I am working on a DB that captures the details of each sales rep

[-Queue-]

Calculations involving GetSummary are useful for displaying summary information in a body part or using summary information in another calc. If you are using subsummaries, which it sounds as if you are, then you should only need to use a summary field based on the 'count of' your hospital ID field and put this in all your subsummary parts and Grand Summary part.

[CLL7]

Thanks for the reply. I'm new at posting, so maybe I didn't give the right info...

I guess I should have said that I created a weighted subsummary using four fields that:

1. count the 'hospitals' (each record is associated with one hospital);

2. shows the total in the found set;

3. calculates the numerical weight of each record; and

4. a summary field that totals the weighted records (or how many unique hospitals were visited)

This summary field works for the subsummary parts, but does not return the correct result in the grand summary on all occasions. Perhaps there is a better way???

[jerilynch]

ALoha - i have a purse company in honolulu - i am trying to get total sales for each year to appear on one report - i am able to create a report that has total sales for 2004 OR for 2003 but not for both on same report

help

mahalo

[RalphL]

Hi jerilynch,

Welcome to the Forum. This should be a subject since it has nothing to do with counting subsummarrry occurrences. You need a field Year = Year (Sale Date). Set up you report to group by year. Sort based on year and enter preview mode and you should get the results you want.

[RalphL]

I assume that your weighted value is 1 / Count of visits to a hospital. Let's say you have a summary field Visits which is a count of HospitalID. Then the weight is 1/GetSummary (Visit; HospitalID).

The number of hospials visited is the sum of the weights which will not be an integar because of rounding errors. Assuming that you have Summary field, No Hospitals, that totals the weight you can get a clean number by using Round (GetSummary (No Hospitals; No Hospitals); 0). You could use the ceiling function in place of round.

[CLL7]

Thanks for the additional info! Will see if this will fix the problem.