rbaintern

I've got a total of a count displayed in the header field. The calculation appears correctly, ut does not display the when I first enter the layout. The odd thing is that when I go to Manage Database, click on the field in question (to try and rectify the problem), and then return to the layout, the number appears! Can any one explain what is going on, and how I might fix this problem? Thank you for your help.

I've tried the following 1) made a new field (temporarily called "TestTotal") 2) made it a calculation of Unstored, = Sum (sCountEmployees) It seemed to work, giving me a total number of all the distinct artists that performed. The problem is when I clear the find, and do another search and then sort, the field is empty!? BUT I when I go into "Manage Database" and then return to the database, the number magically shows up! Can anyone explain this, or can someone explain how I can get this to run properly? Thank you

Thank you all for your feedback. I've tried doing the way comment suggested. I think I have done it correctly. But I can seem to find a way for the report to calculate the total number of distinct artists (i.e. the Total of the Total of cInverseCount) that performed this past season. I think someone addressed this in the older post below; but I can't seem to find a way to do it. I was wondering if there is a way....? One way to do this would be to count the related records in the Artists table. Alternatively, you could sort the records by season and by artist, then count the subgroups as explained here: http://fmforums.com/...post__p__289204 Sorry, I made the previous post without the proper quotation tags. The last paragraph is a quote of Comment's post...

I've looked through here and other places, but I'm still finding it hard to do the following: I have table with records of performing artists and their associated concerts. The fields I have are ArtistID, ConcertSeason, Artist Full Name, (and recently added Mark, Global --trying to follow instructions from a Filemaker Tutorial) Some artists perform in more than one concert in one season, but I need just a count of the number of artists who performed in a certain season-- without a repetition of their names. I've tried a few scripts, but doesn't seem to work well... Any suggestions would be greatly appreciated. I've also got another step to do after and perhaps I shall outline my next question here. I eventually need to count from this set of artists who performed this season, I need a count of how many have performed in this concert series for the first time. So basically--those who do not have records with another ConcertSeason value. I hope I have been clear. Thank you again