Record Count Calc

January 17, 200719 yr

I'm trying to setup what would seem to be a very simple calc that will show the user:

1.) Total Number of Records

2.) Total Number of Active Records

3.) Total Number of Inactive Records

1.) For the total number of records I have a simple "Get ( TotalRecordCount )" calc field setup. (That works fine)

So the user can keep old records in the db but keep track of what's current I've added a field that refers to a single value list "active" and set the field as a checkbox. This allows the user to check or uncheck the box to keep track of which records are active.

2.) To setup a count for the total active records I've created a summary field to get count of "active" records.

3.) To get a count of inactive I'm simply subtracting Total records from total active records (step 1 - step 2).

Problem is that these calculations are victim to a find. If the user performs a find function the numbers for active and inactive records become incorrect.

Anythoughts on how I can do this and not have it affected by the find function.

January 17, 200719 yr

If you have a self join relationship from lets say the "active" field, you can do a count (TableSelfJoin:Active) and it will count all the related records. Or if you have a global field that you can set to the value Active and then you can use a Count() on those related records from the global field to the "Active' field

January 17, 200719 yr

Author

Thanks for answering.

I'm not quite sure how to set that up. Could you be more specific.

Thanks.

January 17, 200719 yr

Ok. Relationship keyed on gActive to Active. The global field will contain only the word "Active". Then you can use a Count (RelationshipName:Active) or a Sum (RelationshipName:Active) (if your Active field is boolean with just 1 being active)