2 Replies Latest reply on Aug 30, 2016 8:29 AM by kbee

    Value List Item Count in Related Table

    kbee

      Hello!

      I have searched and searched and while I think this should be an easy calculation, I have yet to find one that works. Thank you in advance for your help!

       

      I have two tables: People and Program

      The tables are related by Program Name (which is a value list)

      In People, I have a People::Status field, which is a drop-down value list of the following options: "Active", "Applicant", and "Inactive"

      In Program, each of the Program Names are a unique record (with a portal listing all related People records)

       

      The issue I'm having is: In Program, I created "Active Count" and "Applicant Count" fields that I would like to return a count of the total number of each People::Status value for that specific program record

       

      I tried:

      ValueCount (ValueListItems ("Person"; "Status")="Active")

      But it returned a value of 1

       

      I tried adjusting the relationship, but then the portal disappears...any help would be appreciated!