Net Tuition Report (Cognos)
Purpose
To determine the net tuition result of an enrolled student, who has total gross tuition charges, awards and/or waivers applied to their gross tuition, and the resulting amount is considered Net tuition. A basic formula is Total charges - absolute value of (awards and waivers) = Net Tuition, and the resulting discount rate is calculated as a percentage of award and waiver over the total gross tuition charges.
Description
A summary, then columnar based report with detail by school at the student level, which allows a drill thru to the individual student transactions history report.
Additional Details
Link to visualization: