Running Total & Formula

[dBjason]

cr 9

I'm trying to add a running total field in my group footer. I need the running total to sum all Bond;1.Amounts EXCEPT when another detail field has a Bond;1.ReleaseDate. To illustrate, the recordset in SQL looks like this:

No.     Name     Amount     ReleaseDate
4326    Pete     4          09/13/1991
4326    Bob      6          NULL
4326    Sherrie  2          05/19/2005
4326    Shirley  1          NULL
....

I just need the running total to display '7' as that would be the sum of Bob and Shirley (no release dates for them).

I've added the Running total field to my report, and set the Evaluate option to 'Use a formula', and that's where I can't seem to get it to work. I've tried:

IsDate(ToText({s_Bond;1.Amount})) = True

But I just get left with an empty field. Other code I've tried in the formula workshop just seem to add ALL of the amounts, regardless of whether or not they have a release date.

Anyone have any ideas?

Thanks in advance,
Jason

 

[BobSuruncle]

In your Evaluate formula you could try this:

IsNull({s_Bond;1.ReleaseDate}) OR 
{s_Bond;1.ReleaseDate} =Date(0,0,0)

Bob Suruncle

 

[dBjason]

That worked great -- thanks!!!