Count closed cases per month

[veronic]

I am using Crystal 9.0, Oracle DB.
I have a report grouped by month and I have a field BALANCE_DUE.
I need to count how many records per month became with zero balance.

I tried
if {PACS_PROJECT_FINANCIAL.BALANCE_DUE} = 0 then 1 else 0
put this formula in detail and then count and put in GH. Does not work.
And one more thing: BALANCE_DUE field could be null (not only 0)

 

[synapsevampire]

Are you trying to say that you want those that started with a zero balance, or began with a zero balance?

Did not work doesn't help much, is the number low, did the report error?

Try something like:

if isnull({PACS_PROJECT_FINANCIAL.BALANCE_DUE})
or
{PACS_PROJECT_FINANCIAL.BALANCE_DUE} = 0 then
1
else
0

-k

 

[veronic]

I try to count how many projects paid off in particular month. So, if in June Proj#1 had Balance $50.00 and in July Balance = $0.00 then this project was closed in July.

 

[synapsevampire]

Group the report by the date and in the group options select By Month.

Now use the above formula, as in:

if isnull({PACS_PROJECT_FINANCIAL.BALANCE_DUE})
or
{PACS_PROJECT_FINANCIAL.BALANCE_DUE} = 0 then
1
else
0

Place this field in the details, right click it and select insert->Summary->Sum and select for the date group field.

Now you can delete the details formula field from the detail section .

This should provide you with a count per month of those paid off.

-k