Filtering portal data
I have a database tracking students and their classes. I have each students classes showing up in a portal. I have a summary field totalling the units per semester. Classes are listed by section number. The issue is that some section numbers are duplicated in the portal because that section number has different meeting times. Each duplicate section number has the units for that class so what is happening is my summary field is including units twice for the same section number. The data for classes is coming from another source that I import into my database. Any ideas on how to filter out the duplicated units from my summary field?