Record Count Calc

[stealth162]

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.

[mr_vodka]

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

[stealth162]

Thanks for answering.

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

Thanks.

[mr_vodka]

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)

[stealth162]

Call me an idiot.

I guess I need step by step instructions, I tried to set it up and couldn't get it to happen.

Thank you for your patience.

[mr_vodka]

Maybe this will help you.

ActiveCount.zip

[stealth162]

I think I'll be able to get it from that. Thank you so much. :)