So one of the questions that comes up when I am helping customers with this is how do you calculate what percentage of your staff are compliant.

In this scenario, I have set up 16 employees who each have to do a Health and Safety and Induction course. Some of them have done it and some have not. So what percentage of my staff have their courses completed?

Here is the file I start with.

Here is the video that shows you how to do it.

[fvplayer src=”″]


You can view the completed file here..


As always, comments and suggestions welcome.