Such a simple task has proven to be a real pain! I have custom formulas doing conditional counts for a table called
"FalloutTimelineTable".

An example of one of the counts is as follows:

If
{falloutTimelineTable.PROGRAM} In["FNMA10","FNMA15"]
and
{falloutTimelineTable.CLOSE DATE} <> Date(12/30/1899)
Then 1
Else 0

I then sum the result of this formula using another formula to get the count I want.

Sum({@FNMA 10/15 Count})

It is the result of this formula that I place into the report footer. The problem arises when I try to use the same counting method using a separate database table. My other database table is called "FalloutTimelineCalcs"

I am basically trying to count how many variables under "Days Extended" are grater than 0. My formula is as follows:

If
{falloutTimelineCalcs.daysExtended} <> 0
Then 1
Else 0

I then use the same "Sum" function I used before, but when I try to insert the result of that sum function into the report, the report hangs up for about 30 seconds doing calculations for tens-of-thousands of database fields (weird), displays a result that is WAY off, and changes the results of all other summary fields in my report. I am at wit's end here. Any help or suggestions would be appreciated.

Unfortunately, I encountered the same result. The record count is no where near what it should be, and the other summary fields I have in the report have blown up (their values are now in the hundreds of thousands rather than hundreds). I appreciate the help!

I had a feeling it had something to do with the table setup. I have little experience with setting up the links in the table, but the only column of information that matches between the two is called the "Universal Join Column", which I assume is automatically added in by Crystal. The number of rows in the two tables is also the same.

I used a distinct count and the problem still occurred.