cancel
Showing results for 
Search instead for 
Did you mean: 
ahbdent
Canine II

Age report

How can I find the average age of my patient list

0 Kudos
Reply
lindamoseley
CS Dental Employee
CS Dental Employee

From a computer with MS Excel installed do this:

Reports>Patient>Birthday List

In the printer output dialog select to send to EXCEL. 

lindamoseley_0-1659727677502.png

In the Report setup window change the dates to 01/01/1900 to 12/31/2022.

This will capture all active patients in your database. 

lindamoseley_1-1659727804689.png

Click OK

Do not change the file name. Click OK to open Excel.

lindamoseley_2-1659727876185.png

Excel will open. Click the RAW tab located on the bottom of the spreadsheet.

Click the drop-down menu on the  AutoSum button in Excel. Select Average. Look for the column with the age listed. Now click the first age listed and drag down to the last age listed. Click enter on your keyboard when all ages are selected. 

Go back to the top of the page and the average will be displayed. 🙂

lindamoseley_3-1659728344986.png

 

 

0 Kudos
Reply
asmith
CS Dental Employee
CS Dental Employee

Not the easiest report but....here goes! 😊

Reports > Patients > User-Selected.  Add > give it a title > OK.

Now you have to Edit Values, if you have a X in front of topic it will be on report.  Click on each one with an X - uncheck Print and it will not show. If there is something you'd like extra in report , click on that topic and place a X to print. 

When you select Age - you can have 2 groups listed.  I would suggest you do GE (greater than and equal to & LE (less than and equal to)  Such as 20  to 40, or 40 to 60.  But if you want more details you would have to create more reports titled age 1-20, 21-30, 31-40, etc.. Now, you will get a report of ages and total of all in that age group....but it cannot be sent to Excel...which is probably what you wanted. Sorry this is the best I can think of. 

0 Kudos
Reply