This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Created:
Jan 23, 2018 01:05 AM
| Last Modified: Jan 23, 2018 01:13 AM(3970 views)
Hi,
I am working on a project where I have ID and attendance indicator for each ID (0 - Attended, 2 - Non - Attendance). I need to calculate the cumulative non - attendance rate as shown below. I need to know cumulative count of Non - attendance and divide by total count of that ID. This needs to be calculated on cumulative basis.
Appreciate if anyone can help me with a formula / script to accomplish this. Thanks in advance.