Hello, I am trying to calculate total accpetance rate of the students.
I have 2 calculated fields
Accepted Students: case when (acceptance_flag = 1) then count(students)
Total Students: count(students)
I am having a table format and calculation for acceptance rate:
(case when (acceptance_flag = 1) then count(students) )/count(students) * 100
With this, I always get 100% for the every record that is true. Please help with the calculation that needs to be used.