Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Finding number of ID's in a large group of records


Recommended Posts

I have a layout with multiple entries of similar data. For example a line of data contains an ID#, a date, and three quantity fields (number of occurances of case A, B and C). I need a count of the number of ID #s in the total population. and a total of the quantities of Fields A, B and C for each ID#. What is the best way to approach this?

Link to comment
Share on other sites

  • 2 weeks later...

If you only need to see the counts; add a sub summary level to your layout and place a field in your records:

X = Summary ( Count of {ID #s} )

Place the field X in the sub summary portion of the layout and it will display the count of all records in that summary sort


Another approach that I use quite often for complex issues is junk windows.

define a new window, I call them "Junk". I also like to use the Card format with dim background table

Select the Junk window

Do a find on the data in question in as complex a manner as you need

Close Window (Junk)

collect the found record count value or value needed ($Count) and return it as the parameter in the Exit Script ($Count)


May not be two graceful but it works and it is solid. Also leaves you original find and sort in tack.

Link to comment
Share on other sites


  • Create New...

Important Information

Terms of Use