PCR Educator's Data Analytics Tool now lets you decide what an empty cell should say. A new If Empty column on the Fields tab takes any placeholder you type, in any format the field supports, and renders it wherever the data is blank. Reports that used to leave readers guessing now finish their own sentences, in your school's own language.
Why it matters
When a query pulls data from more than one source, for example "show me all students, and their check-in status for today," some students will not have a matching record. Out of the box those cells appear empty, and the reader is forced to interpret. Is the data missing? Is the student absent? Did the report break? Each guess sends staff down a different path, and most of those paths are wasted time.
If Empty removes the ambiguity. You decide what an empty cell should say, so your report reads exactly the way you want it to, the first time, every time.
How it works
- Add any field to your query.
- On the Fields tab, find the new IF EMPTY column (it sits between Aggregate and Pivot Aggregate).
- Type the value you want to display when the field is blank.
- Save the query and run it. Every empty cell in that column now shows your chosen value.
The control adapts to the field type automatically, so the placeholder you type always matches what the field would normally hold:
- Text fields get a text box, and the placeholder also replaces empty strings, not just NULLs.
- Number fields get a text box for a numeric placeholder.
- Yes/No fields get a checkbox.
- Date fields get a date picker.
- Date and time fields get a date and time picker.
- Time fields get a time picker.
Examples in practice
Check-In Status. Set the placeholder to "Not checked in." Viewers see "Not checked in" wherever a student has no check-in record, instead of a blank cell.
Solicitor Assigned. Set the placeholder to "Unassigned." Development reports surface prospects with no owner, so the gift officer who runs the list knows exactly where to start the week.
Emergency Contact Phone. Set the placeholder to "Missing, please update." Staff see a clear call to action instead of an empty field, and the gap closes itself.
Tuition Balance. Set the placeholder to 0.00. Totals add up correctly, exports stay numeric, and the business office stops chasing phantom rows.
Photo Consent. Set the placeholder to "Not on file." Plain English replaces an unchecked box, so the reader does not have to guess whether unchecked means "no" or "not yet asked."
Key benefits
Cleaner reports. No more mystery blank cells, no more reports that read as if they are half finished.
Better communication. Replace technical emptiness with plain English meaning, in your school's vocabulary.
Smarter exports. Excel and PDF exports carry the replacement value, so downstream consumers, board members, parents, and auditors all see the same thing the on-screen reader sees.
Safer joins. When you combine tables with optional relationships, for example students with or without donations, every row reads coherently. Optional joins stop creating cognitive load.
No formula required. Type a value, save, run. No SQL, no expressions, no training, no help-desk ticket.
Where to find it
DAT, then open or build a query, then the Fields tab. The new IF EMPTY column sits between Aggregate and Pivot Aggregate. The feature is available on every field, in every query.
Compatibility
Existing queries are unaffected. The column is optional and defaults to blank, so reports built before this release continue to behave exactly as they always have. Adopt If Empty on the queries that need it, on your own timeline.
A few ways to talk about it
- Blank cells now say what you mean: type a placeholder, save, run.
- One control adapts to every field type: text, number, checkbox, date, time.
- Cleaner joins, cleaner exports, no formulas required, no SQL.
Available now to all PCR Educator schools. Your account team can walk you through the new column, and the examples above, whenever you're ready.