Forum Discussion

QBDevelopment's avatar
QBDevelopment
Qrew Cadet
7 years ago

calculate # of records that have a specific value

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. 
APIs and custom code

1 Reply

Sort By
  • ChrisChris's avatar
    ChrisChris
    Qrew Assistant Captain
    7 years ago

    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 = "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.