Posted: 13 Nov 2017 3:13 EST Last activity: 9 Jan 2018 15:42 EST
Displaying grading in Report Definition
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.