YTD Totals fomula

[samimichaels]

I am trying to find a year to date totals on checks that have been run.

Here is what i am running:
if {CGD_DIST_HEADER.CHECK_DATE}> DateTime (2001, 12, 31,00, 00, 00)then Sum ({CGD_DIST_DETAIL.CHECK_AMOUNT})

This is giving me everything. But I just want the sum where the check date is after 12/31/01.

 

[IdoMillet]

Change your formula to:

if {CGD_DIST_HEADER.CHECK_DATE}> DateTime (2001, 12, 31,00, 00, 00)then {CGD_DIST_DETAIL.CHECK_AMOUNT} ELSE 0

Place it in the detail section and sum it.

Alternatively, create a running total with that condition.

hth,
- Ido CUT (Crystal UTilities): e-mailing, exporting, electronic bursting & distribution of Crystal Reports:

http://sobpc02.bd.psu.edu/CUT/CUT.htm

 

[synapsevampire]

Or if all you'r trying to get is those rows.

In the record selection criteria place:

{CGD_DIST_HEADER.CHECK_DATE} in yeartodate

This will only return rows for this year.

You can also use "yeartodate" in lieu of hardcoding the start of year date in your formula.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com