Run a Calculation

[Robbydobbs]

I want to be able to run a script that says:

If(Code = "1")

Perform Script["Dealer Min 100 Max 200"]

Halt Script

End if

The problem I'm having is creating the script "Dealer Min 100 Max 200". This script will contain the calculation:

If(Price < 200, "Price * .50", If(Price >= 200 < 1000, "100", If(Price >= 1000 <= 2000, "Price * .10", "200"))).

How do I put this calculation into a script?

Dobbers

[Razumovsky]

use set field script step to set your number field.

The calc would be a bit easier with case statement:

case(Price < 200, Price * .50,

Price >= 200 and Price < 1000, 100,

Price >= 1000 and Price<= 2000, Price * .10,

200)

this returns 75 for price=150,

100 for price= 500,

160 for price=1600,

and 200 if price is >2000

HTH

-Raz

[Robbydobbs]

Thank you, I'll do that. Thanks again for your help.

Dobbers