3 Replies Latest reply on Feb 1, 2019 7:50 AM by Diogo Braga

# Rate calculation: numerator current, denominator current -1

The goal is to calculate the recommit rate.

The formula is:

Recommit Rate = Recommit (Clean) for a specific grade and academic year DIVIDED BY Eligible to Recommit for the previous grade and previous academic year.

For example, in 2018-2019, 136 students attend 1st grade and are eligible to recommit to 2nd grade for 2019-2020. As of 01/23/2019, 81 students have recommitted, therefore the 2019-2020 recommit rate for 2nd grade is 81/136 = 60%

• ###### 1. Re: Rate calculation: numerator current, denominator current -1

Diogo,

I did this in multiple steps I used lookup to move a year back:

Previous year Previous Grade Recommit (Previous Grade):

I finally did recommit rate:

See attached and let me know if you have any questions.

Thanks,

Scott

1 of 1 people found this helpful
• ###### 2. Re: Rate calculation: numerator current, denominator current -1

Awesome! Thank you!