Crystal Report XI - Comparison Counting

[kaskins]

I have a report for a Loan Pipeline that is counting the number of days a loan has exisited. This part is working, but when the number of days exceeds 90 but is less than 120, I need to count those loans.


I have this as my formula:

If {@Days}>90 and {@Days}< 120 Then Count ({LOAN_APPLICATION.loan_app_ref_no})

I'm not getting an error, but the results are "0.00" when there are loans that fit the criteria.

what am I doing wrong. Is there a better way to make this happen?

Thank you!

kaskins

[BrianL]

Hi Kaskins,

I would recommend doing this via a running total instead. I'm unclear on exactly what you're counting. If you're counting number of loans, you can set the summary type to "count". If you're summarizing a field based on the criteria, set the summary to "sum".

Set your field to total as {LOAN_APPLICATION.loan_app_ref_no}, and set it to evaluate by the formula:

{@Days}>90 and {@Days}< 120

Reset at the appropriate time (never reset if you want a total count of loans that fit the criteria) and it should work for you.

Hope this helps,
Brian