Show ACTIVE/INACTiVE totals

[Brenda Evans]

Hello everyone,

I hate to bother with this easy question but I just can’t seem to make it gooo.

We purchased File Maker about a week a go for our soccer team to help keep up with stats etc.

I have a layout to show the regular stuff for the players and have a pretty good grasp of how to make basic things work except this problem (this is just a regular database no joins or anything hard like that).

I have a dropdown box that I made a value list for that states ACTIVE or INACTIVE for a field I call STATUS.

I then made fields call ACTIVE TOTAL and INACTIVE TOTAL. And that is as far as I can go. No matter what calculation I attempt to impart I can not get the number of Active players to show up in the ACTIVE TOTAL field or likewise on the Inactive players (keep in mind I know almost nothing about calculations).

Could someone please help with this?

I use Filemaker 8.5 on Windows XP Home

Thank you very, very much

Brenda E.

Edited June 28, 2007 by Guest

[Ugo DI LUCA]

Hi,

You can get this result with a subsummary report grouped by this activeStatus field.

Create a new layout and let FileMaker wizard do this subsummary report for you.

What you need to know is that the result needs to be sorted by this activeStatus Field, viewable in Preview Mode, and reflects the current foundset.

What you need is a summary field involving Count, that would be placed in the subsummary part

There are other method to get this count, but at first, give it a try this way.

[Brenda Evans]

Thank you for your answer. Im not sure if this is what I need or not.

I do not need a report, I need the totals to show up on my layout in the Active or Inactive total field.

Im I not reading your post properly? or will what you described give me what I need.

I apologize as I am really new to this database program but I want to learn.

B.E.

[Ugo DI LUCA]

If what you need is the Total whatever the foundset, then you will need to set up a relationship in order to count these records.

set a calculation 'xShowActive' with this simple formula

"Active"

then add 2 new occurrence of your current Table Occurrence in the graph, one that you'd call Active, the other Inactive

Finally, create

1 ) a relation from your original Table Occcurence to the 'Inactive' with 'xShowActive' matching your StatusField with the relation set to "="

2 ) a relation from your original Table Occcurence to the 'Inactive' with 'xShowActive' matching your StatusField with the relation set to "not equal"

xTotalActive can now be a calculation (unstored) with a formula :

Count ( Active::playerID )

xTotalInactive can now be a calculation (unstored ) with a formula :

Count ( Inactive::playerID )

Another solution would be to change your text to a boolean result of 0 and 1. Well, so many answers.