Logical Function

[gianmigoni]

I'm trying to set a logical function using this parameters:

Case(Quantity ≤ 99 and Code="CFI-WW";"One"; Quantity > 100 ≤ 199 and Code="CFI-WW"; "Two"; Quantity ≥ 200 and Code="CFI-WW";"Three")

It works perfect with the first two but if I enter 200 or more nothing changes.

Thanks

Gian

[gianmigoni]

Problem solved:

Case (Quantity = 0;"0";Quantity ≤ 99 and Code="CFI-WW" ; "310";Quantity ≥ 100 and Quantity ≤ 199 and Code="CFI-WW";"285";Quantity ≥ 200 and Code="CFI-WW";"279")

[Vaughan]

You don't need the "Quantity > 100" part in the statement.

Case (

Quantity = 0;"0";

Quantity ≤ 99 and Code="CFI-WW" ; "310";

Quantity ≤ 199 and Code="CFI-WW";"285";

Code="CFI-WW";"279"

)

What happens if the quantity >0 and code <> CFI-WW?