I have multiple employees under 1 location which each employee has a set range of questions that need to be answered. I want to grab the overall percentage of completion of those questions into a column for the location. So if there are 5 employees with all different overall completion percentages, I want to grab them and basically see how far along the store is. Another tricky thing is I want to use this info across multiple tables. I have a location table that list all the locations and then on my Training table I have a status scoring column. Any guidance will be appreciated. Thanks
LinkedIn
Twitter
