Counting Formula not Working

[Charley71]

I am having trouble getting this formula to return a count. Can someone tell me what might be wrong with it. I am using crystal version 11 developer.

if (GroupName ({@monthname})="January") then count({Gprsfware.SCID})

I need it to count all the records for field SCID that were added in the month of January at the end of the report.

I am not getting an error, just a 0 count. There should be a count of 7 records.

Thanks.

 

[bdreed35]

You need to do this in two steps.
First, create this formula similar to the one you have already:

if (GroupName ({@monthname})="January")
then 1
else 0

Once you have the formula created, insert a summary field that SUMs the above formula for what ever level you need.

~Brian