cowens1

A study of CASE, or a CASE study

Discussion created by cowens1 on Sep 9, 2013
Latest reply on Sep 9, 2013 by LaRetta

Can anyone tell me why this does not work? I get very strange and unpredictable results.

 

Note: y_Cost is a field which holds the cost of an item. I'm trying to develop a mark-up price for that item:

 

CASE (

 

y_Cost < "5" ; y_Cost * "4" ;

y_Cost > "5.01" and y_Cost < "15" ; y_Cost * "3.5" ;

y_Cost > "14.99" and y_Cost < "25" ; y_Cost * "3" ;

y_Cost > "24.99" and y_Cost < "40" ; y_Cost * "2.75" ;

y_Cost > "39.99" and y_Cost < "60" ; y_Cost * "2.5" ;

y_Cost > "59.99" and y_Cost < "100" ; y_Cost * "2.25" ;

y_Cost > "99.99" and y_Cost < "200" ; y_Cost * "2" ;

y_Cost > "199" ; y_Cost * "1.6"

 

)

Outcomes