Summary report Count if absent

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
I'm creating a summary report of consultant evaluations. I have two tables.
  • consultants
  • evaluations
I am trying to list any consultant that does not have any evaluations.

Ideas on how to accomplish this?

Thx.
Photo of Marc

Marc

  • 20 Points

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
If you have a Relationship where 1 Consultant has many Evaluations, edit that Relationships and on the right side add a Summary field to Count the # of Evaluations.

Then just run a report of consultants with a filter of

[# of Evaluations] = 0