Re: CALCULATIONS IN REPEATING TABLE

Clay Fox — Fri, 10 Oct 2008 13:39:11 GMT

It looks like you want conditional formatting on your repeating table to hide the rows if the conditionas you listed are not met.

In the properties you can find that. It will probably take some trial and error to get it. I recommend starting simple and working your way up.

You should be able to just say Sum(TotalFee). If you add a footer to your repeating table and place it there it will sum everything whether it was just inserted or not. Use an expression box with the formula.

CALCULATIONS IN REPEATING TABLE

jennyvera — Fri, 10 Oct 2008 02:33:00 GMT

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.

Newbie Questions

Re: CALCULATIONS IN REPEATING TABLE

CALCULATIONS IN REPEATING TABLE