Specialized Count

[pmusaev]

Please, I have a field that I would like to contain the count of a specific value in a specific field. IE > I have a timesheet file and I would like to count the number of timesheets there are for "Jan 2, 2004" or how many timesheets there are for "Dec 3, 2003" etc... does this make sense? cheers all!

[pmusaev]

Exactly like using the Find function on a specific date... except I need this to be done for all dates entered within the timesheet.

[pmusaev]

"Fraction of Total Of" Summary field seems to do something relevant, now I just have to convert the number it gives me into some sense...

[pmusaev]

Ok, converted the number with a mathematical equation... but it relies on the database to always be sorted by a certain field. Not a big problem, I've just included the sort in every function in the database. Any better ways to do this?

[Oldfogey]

As long as you don't want all the dates at the same time, but just one date ...

Set up

One as Global Number - initialised to '1'

SearchDate as Global Date - used to enter the relevant date

If Date as Calculation = (TimesheetDate = SearchDate )

Selfjoin using One::If Date

Then count( .. some field in the records ..) will give you the number of records.

[MoonShadow]

Hi pmusaev,

Instead, you might consider a self-join. In Define Relationships, create a new relationship and select this same file. Join DateField (on the left) with DateField (on the right).

Create a calculation (number) with: Count(selfjoin::DateField)

Each time a timesheet is displayed, it will show how many other timesheets have the same date.

If this is just informational purposes (ie, you need a weekly report), you could instead use a Columnar/List report with grouped data. Categorize by your DateField. Create a summary which would be Count = Datefield and place the summary after the body. Be sure to sort by Date.