Running total inside of a Running Total?

[azaveri]

Hey guys,

1. I have a date field (Date1). I use a running total with a type of summary set to "Maximum" to obtain the most recent date(MostRecentDate1).

2. I also have another date field (Date2).

3. I then use a formula to obtain the difference in days between MostRecentDate1 and Date2 (Number1).

4. I have another number field (Number2).

5. I then compare Number1 to Number2. If Number1 is less then or equal to Number2, I count the record. If it isn't, I ignore the record.

6. The only group I'm using is for Date1 to obtain the most recent date (MostRecentDate1).

When I attempt to do a second running total for the number of records (Point 5.), Crystal won't let me since I'm already using a running total to obtain the most recent date (Point 1.).

How could I go about achieving my record count?

Thanks.

 

[lbass]

Please show the actual content of your formula in #3.

-LB

 

[azaveri]

Thanks for the reply. I ended up getting assistance from one of our developers who showed me how to program it directly in SQL.