calculation field pulling from wrong record
i created a new layout/report to show each record (ie student) listed by supervisor with the tuition amount charged and the funding provided. it works fine, except it's pulling the funding from the wrong academic year. each student has multiple records in the funding layout, one for each academic year. how can i get it to pull the amounts from the chosen academic year?