Calculating averages and std deviations from portal fields
I have a database solution where a single patient record is related to a table contains antibiotic prescriptions where there may be multiple prescriptions per patient record
i have calculated the total antibiotic days for each patient record in the antibiotic table
i have a search page where users can search and display pt records by gender, age, hospital, etc, and I would like to display both the average antibiotic days of therapy and std deviation for the found set.
i have tried to use the GetSummary function to do this but I am not sure what should be specified as the break field - all the solutions I have tried just displays the total days of antibiotic therapy for each individual record