Add VALUES to field

[Ryanw]

Lets say I have a dropdown field,

Trucks

Cars

Vans

I need to add a value to each,

Trucks = 30%

Cars = 20%

Vans = 10%

So, if I were to choose VANS which had a value of 10%, and entered $100.00 into the 'price' field, then 'total' would come to $10.00

Hope you can help!

Kind regards,

Ryan

[Lee Smith]

Assuming that your List is called Vehicle, and your % is based on a field called Price:

Case (

Vehicle = "Truck" ; Price*.3 ;

Vehicle = "Car"; Price*.2;

Vehicle = "Van"; Price*.1 )

However, I would make a related file out of the vehicle and percent.

Attached is a simple file showing this approach.

HTH

Lee

Commission.fp7.zip