I'd like to use a case statement, but not sure how to script it....

I need a result for weight breaks...

See attached example.

The first is easy, how do i do the rest?

"and" & don't work....

Case (

Load Optimization::INWeight ≤ 499; .49;

Load Optimization::INWeight ≥ 500 & ≤ 999; .43;

)

Case() stops evaluating after the first condition that returns True.

In your case, if the INWeight is less than or equal to 499, then the Case statement exits with a result of .49. Otherwise the statement moves on to the next case. The last line in your Case statement is your default

So, your Case statement would look like this:

Case (

Load Optimization::INWeight ≤ 499 ; .49 ;

Load Optimization::INWeight ≤ 999 ; .43 ;

Load Optimization::INWeight ≤ 1499 ; .33 ;

// Else

.1

)