Count based on Gift Date 1

[Pete271]

I'm using CR8.5 and trying to insert a formula to count gifts if they've been received after a certain date.

My attempt is

if{Gift.Date} > Date (2006,07,31)
then sum ({Gift.Amount})

I then want to put a subtotal in for each group, but that isn't going to well either because it seems to be picking up all the gifts not just the ones after the date above.

Thanks in advance.
Pete

 

[lbass]

Your formula should be:

if{Gift.Date} > Date (2006,07,31) then
{Gift.Amount}

Place this in the detail section and right click on it and insert a summary at whatever level you like. This will sum the gift amounts. If you want to do a count, change the formula to:

if{Gift.Date} > Date (2006,07,31) then 1

Then insert a sum (NOT a count) on this formula.

-LB