Counting unique # of days?

[Cin]

I'm trying to find an daily balance average. I want to count how many unique days are in my find. For instance I have a find made up of 6 records. Out of the six records there are 3 unique days. Jan 1, 8, 22. I want to be able to use 3 in my average calculation

SumLineItemTotal/UniqueDays

Can anyone clear the cobwebs?

Thanks!

Cin

[Ender]

I think this would work: Define these two fields:

Count of Records (Summary) = Count of Record ID

Count of this Date (Calculation, Number) = GetSummary(Count of Records, Date)

You must sort by Date (the break field) for the GetSummary() to work.

[Cin]

Thanks for the quick response. I tried that and it adds one to it.

Cin