Calc that references 2 fields, then by FY

[zenboy32]

I need to track all enrollees for a given program. There are Enroll Date and Cancel Date fields. I want to count the number of consumers that are enrolled (Enroll Date) and have not been cancelled (Cancel Date).

I also need to count to total enrollments, total active and total cancellations for a given fiscal year.

I appreciate any help offered.

[LiveOak]

Define the following fields:

Enrolled (calculation, number) = NotIsEmpty(Enroll Date)

Active (calculation, number) = NotIsEmpty(Enroll Date) and IsEmpty(Cancel Date)

Cancelled (calculation, number) = NotIsEmpty(Cancel Date)

Total Enrolled (summary, Total of Enrolled)

Total Active (summary, Total of Active)

Total Cancelled (summary, Total of Cancelled)

Find the records for a given fiscal year and place the summary fields on a layout to view or print.

-bd