Field Calculations

[Robbydobbs]

I have 10 different field calculations that represent commission types. I need only to assign one commission per client. How would I assign each client their commission permanently and have it calculate?

[Lee Smith]

Hi Dobbers,

Have your commission field be a calculation field based on your commission types field. Commission Type should be a Value List.

Use a case statement as the calculation in commission field. Your calculation should look something like:

Case(

commission types ="Straight", 110,

commission types = "Special", 115,

"")

Be sure that the types of commissions are exact (no variation in spelling between your types and what you put into the calculation) Copy and paste works for me.

I have also enclosed a small file to show you what I mean.

HTH

Lee

commission types.fp5.zip

[danjacoby]

And, to ensure that "the types of commissions are exact", the commission types should be entered from a popup list.

[Lee Smith]

Hi Dan,

> And, to ensure that "the types of commissions are exact", the commission types should be entered from a popup list.

Did you miss the Value List part of my reply?

Very little value in creating a Value List if you are not going to attach it to a field in some manner.

My attachment also demostrated it too.

HTH

Lee

[Robbydobbs]

Dan, thank you for your advise and help. Your solution is a great idea, but I should of been more in depth in my description. My commission types are results of calculations and not just a whole number. In other words for the following commissions, here are the calculations:

Bank Sliding with Max 550

If(Price > 1000, "75", If(Price >= 1000 <= 3000, "150", If(Price > 3000 <= 5000, "200", If(Price > 5000 <= 8000, "250", If(Price > 8000 <= 10000, "300", If(Price > 10000 <= 20000, "350", If(Price > 20000 <= 30000, "450", If(Price > 30000 <= 40000, "550", If(Price > 40000 <= 50000, "650", "750")))))))))

10% with max 500

If( Price <= 5000 ,Price * .10 , 500 )

Donation with max 150

If(Price <= 400, "50", If(Price > 400 <= 1000, "100", "150"))

Also I need these commissions not only be tied into the client, but also to the different types of products that they may purchase.

For example:

Client Joe Smith, he may have two purchases (1)A Tractor and be assigned the sliding bank commission and (2)purchase a donation car and be assigned a donation commission for that purchase.

Would it be best to setup a conditional value list with 4 fields which would include client, purchase, commission and a Commission ID Number and select the particular ID Number to setup the different commission types, or should I run a script for each individual client to decide how to charge the commission?

Any help would be greatly appreciated. I know what I want to do, but I don't know exactly the correct way to set it up.

Thanks

Dobbers