Need help with calculation for a report

Hello,

i was wondering if someone can help me with this. i am running FM 6.0
on the mac. I am building a report to track past due students. here
is what i have:

I have class that has 10 students, out of those 10 student i can tell
what payment plan they are. what i cannot figure out is how many
student are past due base on the payment plan and what their total are
for all those student that are on the plan.

my fields are:
count - give me the total of students
paymentplan - give me the total student base on their plan which is
"Monthly"
balancedue - how much is due.

so if i have 10 student in a class, 4 those are in the monthly payment
plan, how out of the 4 are past due and what is the total amount of
money combine is?

i need to figure out how to do Calc that will be check if the student
is >0 in their balance due and what the total of amount is.

Re: Need help with calculation for a report

In article <1189440313.783157.305220@19g2000hsx.googlegroups.com>,
WebMaster wrote:

> Hello,
>
> i was wondering if someone can help me with this. i am running FM 6.0
> on the mac. I am building a report to track past due students. here
> is what i have:
>
> I have class that has 10 students, out of those 10 student i can tell
> what payment plan they are. what i cannot figure out is how many
> student are past due base on the payment plan and what their total are
> for all those student that are on the plan.
>
> my fields are:
> count - give me the total of students
> paymentplan - give me the total student base on their plan which is
> "Monthly"
> balancedue - how much is due.
>
> so if i have 10 student in a class, 4 those are in the monthly payment
> plan, how out of the 4 are past due and what is the total amount of
> money combine is?
>
> i need to figure out how to do Calc that will be check if the student
> is >0 in their balance due and what the total of amount is.

With no dates (or at least how months) involved, you're going to find
it impossible to work out who's payments are past due.

If they are dates involved, then you would probably be best with a
realted file of payments so that you can find out when the last payment
was, compare it to Status(Current Date) and then know whether or not
another one is due / overdue.

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)