Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need to get the average across the 4 student per category highlighted in red.
For now, I can get the average score per student for each category. I am using the following expression:
=(SUM({$(eMPE_Set)}QuestionData)/
COUNT({$(eMPE_Set)} Record_No))/
Max({$(eMPE_Set)}MaxRatingScore)
The MPE expression is a set expression to get a specific exam type, example. English.
1. QuestionData is the score value.
2. Record No is a count of the number of records.
3. MaxRating Score is the maximum score of each questions.
4. The result of the above expression is translate into %.
What am I missing? Can anyone please guide me on this?
Thanks
Chun Wey
Thanks Tresesco! You're good!!