I wanted to display grading in report definition, I have created a report definition where there are total number of resolved cases for an each operator will be displayed. Based on the total number of resolved cases, I have a new column Grade, where the grading will be displayed. For example, if the total number of resolved cases are 10 for an operator, and that operator has resolved 9 cases, then, that operator should have Grade-A, as that operator has more than 90% resolved cases. I want the grading as per the below calculation:
90 - 99 --> Grade A
80 - 89 --> Grade B
70 - 79 --> Grade C
Below 70 --> Grade D
Based on the resolved cases for each operator, grade should be displayed in that report definition.
Can you please help me the best approach for this requirement.