Purpose of report
To show which courses are making a profit (or not), and compare occupancy rates. This should inform the Training Director which modules are worth keeping/marketing/dropping/reevaluating
What entity is this report built from?
the Event entity
My report is showing multiple lines per event
Ensure you have the filter "Disposition" set to "not equals - Session". This will give you the parent event rather than each individual session
How do you do the formulas?
Go to output columns and click on the Advanced checkbox (bottom left). Now you can add a formula by clicking on the "Add Formula Column" near the top of the output columns