Calculations

[LTAN]

I have a repeating table with 5 columns. I have combined the Type and Course
into one drop down list box since I wasn’t able to configure the 2 drop down
lists in the repeating table.

Type/Course CourseFee No. of Days Participants TotalFee

Type/Course is a dropdown list box. The lists are as follows:
• Standard/ Automotive
• Customized/ Automotive
• Standard/ Speech Power
• Customized/ Speech Power

I was able to do what you have taught me. Thank you. If I choose STANDARD,
the course fee and duration are automatically displayed.

The ff. are the sample STANDARD TRAINING (These are fixed)

Type/Course CourseFee No. of Days
Standard/Automotive 50,000.00 5
Standard/Speech Power 80,000.00 3

I would like to ask another favor, if you could help me with this:

The ff. should be displayed if CUSTOMIZED has been chosen. I think these
should also be based on the COURSE FEE of STANDARD TRAINING

• Case 1 – if the NO. OF DAYS is reduced, the course fee should be the same
as the STANDARD's COURSE FEE.
• Case 2- if the NO. OF DAYS exceeds in the STANDARD, the COURSE FEE should
also increase per day.

For example, CUSTOMIZED / AUTOMOTIVE has been chosen. These should be
displayed.

Type/Course CourseFee No. of Days
Customized/Automotive 50,000.00 3

For example, CUSTOMIZED / SPEECH POWER has been chosen. These should be
displayed.

Type/Course CourseFee No. of Days
Customized/Speech Power 80,000.00 2


For example, CUSTOMIZED / AUTOMOTIVE has been chosen and exceeds the no. of
standard days of training. These should be displayed.

Type/Course CourseFee No. of Days Participants Total
Fee
Customized/Automotive 50,000.00 6 1
60,000.00

Note: TOTAL FEE (COURSE FEE * NO. OF PARTICIPANTS)

Thank you very much.