Aggregate function not working

[Edge]

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?

[rubenmarin · Accepted solution]

Hi, maybe with:
Avg({<RetentionModel.CumGPA-={0}>} aggr(DISTINCT RetentionModel.CumGPA, RetentionModel.EMPLID,RetentionModel.CumGPA))

[Edge]

Many Thanks Rubenmarin 🙂