Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello.
I have a table that has multiple entries for each student for different information. but I want to find out the average GPA for these students excluding duplicate rows. The below expression doesn't work with me though:
aggr(DISTINCT Avg(RetentionModel.CumGPA),RetentionModel.EMPLID,RetentionModel.CumGPA)
Also, if I want to add set analysis like to exclude GPA of Zero, where in this expression can I do this?