Quick Base Discussions

Expand all | Collapse all

Summary report Count if absent

  • 1.  Summary report Count if absent

    Posted 11-14-2017 13:38
    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.


  • 2.  RE: Summary report Count if absent

    Posted 11-14-2017 14:11
    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