Not sure what you want the end result to look like. Are you looking for something like this?
UserID Course Name Other Value 1 Course 1 24 1 Course 2 24
It would essentially be an average. If a user has a 3rd course with different total it could end up being not what you're expecting.
But to do this you could do.
aggr(nodistinct (Sum(OtherValue) / Count(DISTINCT [Course Name])),UserID)