Good afternoon --
An even easier way to solve the issue is to enter a zero grade when a student doesn't complete an assignment. The zero grade will calculate and show an accurate average.
If you accept late work (which I do not), you can always change the zero to an earned grade. When students see the immediate impact of a zero grade on their average, it is sometimes quite motivational.
Have a nice day,