I have a Price field that I would like to auto-calcualte based on which answer is chosen from a dropdown list.

I have a Member field, which is either a Yes or No, chosen from a dropdown list. The Member cost is $35, the Non-Member cost is $40.

I would like the Price field to auto calculate the price based on either the Yes (Member) or No (Non-Member).

I know I start with price= in the formula, but which would be the correct stament to make the choice?

Thanks in advance for your help.

Try:

Your Calculation Field, I'll use Price,

Price (calculation, Result Number) =

Case (Member = "Yes"; 35; 40)

HTH

Lee

Edited May 29, 200817 yr by Guest

Prices change from time to time, and it's not a good idea to hard-code them into calculations. Use a lookup instead.

BTW, price must be of type Number, otherwise you won't be able to summarize it.

Oops.

I changed the results to number.

Good point about hard coding the amount.

Lee

Thanks, that did the trick.

It is a number field.

These numbers will not be changing. They are set prices for a trip reservation program that I am creating.

Edited May 29, 200817 yr by Guest