Jump to content

Add VALUES to field


This topic is 5603 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 5603 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.