Jump to content

# Specialized Count

This topic is 7097 days old. Please don't post here. Open a new topic instead.

## Recommended Posts

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!

##### Share on other sites

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

##### Share on other sites

"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...

##### Share on other sites

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?

##### Share on other sites

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.

##### Share on other sites

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.

##### Share on other sites

This topic is 7097 days old. Please don't post here. Open a new topic instead.

## Create an account or sign in to comment

You need to be a member in order to leave a comment

## Create an account

Sign up for a new account in our community. It's easy!

Register a new account

## Sign in

Already have an account? Sign in here.

Sign In Now
×
×
• Create New...

## Important Information

By using this site, you agree to our Terms of Use.