Discussions

Expand all | Collapse all

calculate # of records that have a specific value

  • 1.  calculate # of records that have a specific value

    Posted 04-26-2018 20:21
    I'm trying to calculate the number of records that share a specific value, and I want this number to appear in each record. For example if 5 out of 10 records have value x in field y, I want every record with value x to show the number 5. 

    Does anyone know how to do this easily? I'm looking at the API_GetNumRecords, but I'm not sure how to deploy it. 


  • 2.  RE: calculate # of records that have a specific value

    Posted 04-26-2018 20:26

    If you have a parent table related to the table in question, you can set up a custom summary field in the parent that summarizes the number of child records where [y] = "x". I'm taking you literally. You will have an easier time of doing what you want this way. Then, you can pass the value back into the child table as a lookup field.