pls. help. thanks

[LTAN]

SAMPLE REPEATING TABLE

Course CourseFee Duration Participants Discount TotalFee

Allowance

Course=drop down list box, whenever you choose one of the list, it
automatically displayed the corresponding info in the CourseFee and Duration.

Participants = dropdown list box, whenever you choose one of the list, it
automatically displayed if it has a discount.

I have to get the total allowance which is based on the no. of duration *
300( allowance per day). I would like to ask what should be the formula for
allowance to display only the result if the user of the form chooses the no.
of participants.

I have used this formula in the allowance = duration * 300, it works but it
displayed the allowance even if there was no input in Participants drop down
listbox. This is because whenever they choose one of the list in the Course
dropdown listbox, it automatically displayed the duration and then the
allowance is automatically computed. I want to display the result only after
they have chosen how many participants. Can u help me how to do this using
rules? Thanks again.

 

[Pramod K.]

Hi LTAN,

Set a rule on participents to make the allowance field value blank, if the
participents is blank.

 

[Pramod K.]

SAMPLE REPEATING TABLE

Course CourseFee Duration Participants Discount TotalFee

Allowance

Course=drop down list box, whenever you choose one of the list, it
automatically displayed the corresponding info in the CourseFee and Duration.

Participants = dropdown list box, whenever you choose one of the list, it
automatically displayed if it has a discount.

I have to get the total allowance which is based on the no. of duration *
300( allowance per day). I would like to ask what should be the formula for
allowance to display only the result if the user of the form chooses the no.
of participants.

I have used this formula in the allowance = duration * 300, it works but it
displayed the allowance even if there was no input in Participants drop down
listbox. This is because whenever they choose one of the list in the Course
dropdown listbox, it automatically displayed the duration and then the
allowance is automatically computed. I want to display the result only after
they have chosen how many participants. Can u help me how to do this using
rules? Thanks again.