1 2 3 Previous Next 32 Replies Latest reply on Jul 6, 2015 2:31 PM by gremlin9297

    How to count unique values of a field with multiple values?

    openspace

      I have two tables:

       

      Donation Request Table >--Donation Table

       

      The donation request table contains a list of contacts that have made a donation request, each donation request is linked to one donation, and multiple donation requests can be linked to one donation. In other words multiple contacts can make one donation.

       

      Donation Request Table

      ID1     Ezra

      ID2     Tyler

      ID3     Jacq

      (3 donors)

       

      Donations Table

      ID1    EzraTyler

      ID2    Jacq

      (3 donors, 2 donations)

       

      How do I count the number of unique donors, while on a layout in the donations table? So far I have been able to count the total number of donors in the donation request table and then use that value in the donations layout, but the disadvantage is that is is not a dynamic count of the visible records on screen, rather a static total. 

        1 2 3 Previous Next