Summary Report with zero assessments

  • 0
  • 1
  • Question
  • Updated 10 months ago
  • Answered
I'm trying to create a summary report of consultant assessments. I have two tables.
  • consultants
  • assessments
I am trying to list any consultant that does not have any assessment.

Ideas on how to accomplish this?

Photo of Marc


  • 70 Points

Posted 10 months ago

  • 0
  • 1
Photo of Alex Gale

Alex Gale

  • 1,462 Points 1k badge 2x thumb
I'm assuming you have a one-many relationship here, with Consultants having many Assessments. 

It sounds like what you want is a summary field, which you can then use to filter a regular report. You can set up a summary field called # of Assessments on the consultants table to count all related assessments. Then, you can simply filter any report to only include consultants where # of assessments = 0