Removing null values from report
I am migrating a custom interview schedule report to the new tool. The report gives me a formatted interview schedule grouped by interview date and candidate.
When I run the report for certain candidates I am getting blank rows of data. This appears to be because the candidate had an interview schedule on their record that was later deleted. An an example, my candidate had interviews scheduled for 10/28 and 10/31 for different positions. I went in today and deleted the interview schedule for 10/31 but when I run the report I get a blank row for the 2nd position although there is no actual interview in the system.