These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Calculation Issue

kevingib
Registered: Jan 10 2008
Posts: 9

I am working an a financial contract for re-enrollment at our school and have run into a brick wall. Basically I have a form that will act as a parent contract for tuition and they complete the form to determine their total tuition minus any discounts based on number of children and payment type.

The easy part was creating the form and the logic and getting a total dollar amount.

The form is setup so that a student grade is selcted in a drop down box (Grade1) and the form contains 5 of these boxes named differnt things for multiple kids. Each pf these drop down items has a value equal to the tuition amount. Next to this box is another box that is called Payment1 which reflects the plan the parent wants and I have one of these for each child as well. The values in this drop down equal the discount % based upon what plan is chosen such as annul %5 so the value is .95.
The calculation at the bottom to get the total is as follows:
sum(Grade1*Payment1+Grade2*Payment2*.9+Grade3*Payment3*.8+Grade4*Payment4*.8+Grade5*Payment5*.8)

The total works now the tricky part comes in. I need to be able to display 3 more boxes that represent the following
Annual Payment (Lump Sum)
Bi-Annual payment (Twice a Year)
Monthly Payment ( Paid by debit on the 5th)

The logic would be to use the total for the annual, divide by 2 for bi-annual and divide by 12 for monthly. The problem is I need to know what plan they picked to be able to enter the daa in the correct field and if they choose more than one plan I need to calculate it so that if they want 1 child to be annual and 1 to be monthly they will see an amount on both lines that equals the total amount above when calculated out.

I dont see a way to attach my form but if you think you cna help and understand what I am doing then emal me and I send you the form to review.

Thanks,
Kevin

gkaiseril
Online
Expert
Registered: Feb 23 2006
Posts: 4308
Use one drop down box to select the payment frequency. For multiple children, you will need a drop down box for payment frequency for each child as well as the totl fees and tuition for each child.

George Kaiser

kevingib
Registered: Jan 10 2008
Posts: 9
I have that currently. The question is how can I determine, using formcalc, what the totals are for what is due once they make their selections.

If a parent chooses two different payment plans I need to be able to evaluate each of the plans and display what is due