Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I am reading data from Excel where we have below details. Is there a way to calculate Average and count based on the below mentioned logics ?
ID | NAME | Salary | Designation | Q1-Rating | Q2-Rating | Q3-Rating | Q4-Rating | Yearly Average Rating | Count |
1 | A | 10000 | Tester | Blocked | Blocked | 5 | 4 | calculate based on Q3 and Q4 | Count of Quarters where we have a data |
2 | B | 20000 | Developer | 3 | Blocked | Blocked | 4 | Calculate based on Q1 and Q4 | Count of Quarters where we have a data |
3 | C | 15000 | Lead | 3 | 5 | 4 | 4 | Calculate based on all quarters | Count of Quarters where we have a data |
4 | D | 20000 | Manager | 5 | 5 | Blocked | Blocked | Calculate based on Q1 and Q2 | Count of Quarters where we have a data |
Hi
What is your expected output
thanks for your reply. Please refer the last 2 columns for the same. Feel free to revert in case anything.