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
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!