AnsweredAssumed Answered

Calculating averages and std deviations from portal fields

Question asked by GiulioDidiodato on Jun 3, 2014
Latest reply on Jun 3, 2014 by philmodjunk

Title

Calculating averages and std deviations from portal fields

Post

     Hello

     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

     Suggestions?

      

      

Outcomes