Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 1957 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

Hello,

im a little stuck.

in a DB, I have a field that is a calculation of three other fields, [length], [connector.type], [pairs]. An example in that field might be “100’ G3 15pr”

Im trying to do a report that gives me the found count of every value that the calculation field has.  Basically, how many “100’ G3 15pr” do I have in my DB

Im sure it’s an easy find, but I’m drawing a blank.  Is this a simple function I can do in a report, or is it a scripted thing?  Can anyone point me in the right direction please?

 

Thank you,

Tony

Posted (edited)

Fields do not have a found count. If you perform a find, then you can use the Get (FoundCount) function to count the records in the current found set.

If you want a report that shows how many records are in each group of records (within the current found set), then sort your records by the category field and place a summary field defined as Count of [any field that cannot be empty] in a sub-summary by category part.

 

Edited by comment

This topic is 1957 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.