Forum Discussion

MarcHilliker's avatar
MarcHilliker
Qrew Trainee
8 years ago

Summary report Count if absent

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.
reports and charts
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    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