Calculating FROM 100% DOWN rather than UP TO 100%
I keep attendance for my Rotary Club. In the attached graphic, the field on the right is calculating percentage of attended meetings as the weeks pass by. James K. Adams would reach 100% when and if he attends all meetings through September 24.
I would like for the calculation to say that the Rotarian’s attendance is at 100% until he/she misses – thus calculating FROM 100% DOWN rather than UP TO 100% as it is presently doing.
In this graphic, I want Adams, Benedict, and Biggerstaff to show 100% as of July 16. The percentage will drop if they miss a meeting along the way. Abbott would show 66%. Aldridge and Alvarado would show 33%, etc.
Can you tell me how to accomplish this task? Thank you so much.