This content has been marked as final.
Show 7 replies
-
1. Re: How to count the Grades if the grades are aggregated?
Hari AnkemOct 31, 2019 7:07 PM (in response to Leonard Wong)
Please attach your packaged workbook (.twbx).
-
2. Re: How to count the Grades if the grades are aggregated?
Leonard Wong Oct 31, 2019 9:01 PM (in response to Hari Ankem)Thanks for Replied. I've attached the twbx file
-
3. Re: How to count the Grades if the grades are aggregated?
Hari AnkemOct 31, 2019 10:48 PM (in response to Leonard Wong)
Is this the expected output?
If yes, you can check out what I did in the attached workbook.
Note: I have deleted all the sheets and the source which were not needed so that it was easy to work with.
-
testbook2.twbx 217.4 KB
-
-
4. Re: How to count the Grades if the grades are aggregated?
Leonard Wong Nov 27, 2019 6:19 PM (in response to Hari Ankem)Thanks Hari. It is what I'm looking for. It is awesome.
-
5. Re: How to count the Grades if the grades are aggregated?
Hari AnkemNov 27, 2019 7:21 PM (in response to Leonard Wong)
You are welcome!
-
6. Re: How to count the Grades if the grades are aggregated?
Leonard Wong Dec 2, 2019 12:22 AM (in response to Hari Ankem)Hi Hari,
But i realized the calculation is incorrect. For example, it should be only 1 A but it shows 3, i believe is because you calculate the company and PIC individually.
-
7. Re: How to count the Grades if the grades are aggregated?
Hari AnkemDec 2, 2019 9:38 PM (in response to Leonard Wong)
I do not know your business requirement. So, please modify the formulas as required to get the desired results.