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
George Kaiser