calculation based on a value list

[jessebSF]

hey all, and thanks for any help:

here is the issue:

i am trying to create an invoice where the description of the purchase appears (field B- currently a calculation field with choose as the function) on the basis of what value is chosen in another field (field A). that field (A) is a value list with four values. all are about 4 words of text. i have tried with field A formatted as both radio buttons and a drop down list, and it didn't work with radio buttons and it (: will only choose the first option in the choose calculation when the other field is formatted as a drop down.

any ideas?

thanks!

[Ender]

Perhaps you can post your calc, and give an example of the data with what you'd want the calc to return.

[jessebSF]

here is the calculation, as it is currently formulated.

it keeps resulting in "1 ticket & Business Card size ad"

Choose(Yes Ad size 10th="Freshman ($100-250)", "1 ticket & Business Card size ad",

Yes Ad size 10th = "Sophomores ($250-$500)","2 tickets & 1/4 page ad", Yes Ad size 10th = "Juniors ($500-$1,000)", "5 tickets & 1/4 page ad", Yes Ad size 10th = "Seniors ($1,000-$2,500)", "10 tickets & 1/2 page ad", Yes Ad size 10th = "Graduates ($2,500 and up)", "10 tickets & full page ad","")

[Ender]

Looks like you should be using a Case() statement instead of Choose().

[jessebSF]

that's it. that was so easy, thanks Ender!

Would it still work if the field A is formatted as a radio button?

thanks a lot.

jesse

[Ender]

Sure. A field definition doen't care whether value lists are applied or not.