Do you have a sample workbook or sample data? and how did you calculate the visits per 1000?
Unfortunately I cannot provide the data due to PHI. I use pivot table to calculate visits per 1000 after running SQL code ( that gives the sum of ED visits in a particular region for instance- see below) but I wanted to know how I can incorporate Ed visits per 1000 instead into my code instead of getting sum of ED visits to get ED visits per 1000.
SUM(ED_VISITS) AS ED_VISITS
Visits per 1000 = Visits/ member count X 12,000