So, what you want is:

do case
  case alltrim(materialid) $ "VX29,VX39"
     * use qty3
  case alltrim(materialid) $ "VX57,VX50"
     * use qty2
  case materialid = "VX51"
     * use qty
  case alltrim(materialid) $ "CJ30....CJ40"
     * use 2
  otherwise
     * use 1
endcase

is that logic correct? Then the immediate iif would be:
iif(alltrim(materialid) $ "VX29,VX39", qty3, iif(alltrim(materialid) $ "VX57,VX50", qty2, iif(materialid = "VX51", qty, iif(alltrim(materialid) $ "CJ30....CJ40", 2, 1)

is that ok?


>I have a problem with my nested immediate if statement. The problem is if a materialid equals VX5 it is given it the value of qty2 when it should be given the number 1. It is VX50 or VX57 that have to be an exact match to receive the value of qty2. The same is true for the rest of them.
>
>Here is my statement.
>
>iif(alltrim(materialid) $ "VX29,VX39", qty3, iif(alltrim(materialid) $ "VX57,VX50", qty2, (iif(alltrim(materialid) $ "VX51",qty, (iif (alltrim(materialid) $ "CJ30,CJ31,CJ32,CJ33,CJ34,CJ35,CJ36,CJ37,CJ38,CJ39,CJ40", "2","1"))))))
>
>Can anyone help me with the correct syntax that will give me the totals that I want.
>
>Thanks in advance,
>Tyler