AVG Per Customer Purchase Order

I need to find the average “DaysLate” for each Purchase Order created per customer. I cannot figure out a way to average the calculated field per specific customers. Any help would be greatly appreciated.

Thank you!

Hi Nick,
If you right click on the table header > Show Group By > Drag the name to the top so it groups them by name and then right click on Days Late > Show Summaries then Click on Averages.

Should end of up with something similar to this image

Thank you so much! Of course it was much easier than I thought!

Thank you again for the help!

1 Like

No problem! Glad I could help.