I have a repeating table with 5 columns.
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
In the first column of the table: TYPE/ COURSE, 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 any help 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 TotalFee
Customized/Automotive 50,000.00 6 1 60,000.00
Note: TOTAL FEE (COURSE FEE * NO. OF PARTICIPANTS)
Also, how would i sum up all the rows in repeating table using rules? i've tried using SUM Function but it didnt work for the additional row i inserted in the repeating table. since i dont know how to include it in the formula since that additional row came from the INSERT ITEM of the repeating table. when im on the design mode, only the first row of the repeating with its fields are only displayed. thank you.
Can you help me with the Rules and Actions i need to implement since im not a programmer. Thank you
very much.