multiple iffs

[webisti]

Hi I am trying to apply a multiple iff
here is the code:
STATUS: IIf([013_MK_S]![MOVEMENTS]>5,"FAST MOVER","IIf([013_MK_S]![MOVEMENTS]<5 And >3,"MEDIUM MOVER","IIf([013_MK_S]![MOVEMENTS]< 1,"SLOW MOVER","0")))
But is not working..where I am doing the error?



thanks for he help

Webisti

[Bob Fitz]

Try this:
STATUS: IIf([013_MK_S]![MOVEMENTS]>5,"FAST MOVER",IIf([013_MK_S]![MOVEMENTS]<5 And [013_MK_S]![MOVEMENTS] >3,"MEDIUM MOVER",IIf([013_MK_S]![MOVEMENTS]< 1,"SLOW MOVER","0")))

[jzwp11]

I do not think that you can have ([013_MK_S]![MOVEMENTS]<5 and >3, you need to repeat the name of the control between the "and" and the >3



STATUS: IIf([013_MK_S]![MOVEMENTS]>5,"FAST MOVER","IIf([013_MK_S]![MOVEMENTS]<5 And [013_MK_S]![MOVEMENTS] >3,"MEDIUM MOVER","IIf([013_MK_S]![MOVEMENTS]< 1,"SLOW MOVER","0")))

BTW what happens if [013_MK_S]![MOVEMENTS] is greater than or equal to 1 but less than or equal to 3? You do not define that category.

[webisti]

Thanks It worked with the separate name controls.
Actually what I want is this definition
Fast >5 medium is between 2 to 5 a
slow is equal to 1 or less.

Is then anothwe way of doing it?

[Bob Fitz]

Try this:
STATUS: IIf([013_MK_S]![MOVEMENTS]>5,"FAST MOVER",IIf([013_MK_S]![MOVEMENTS]<5 And [013_MK_S]![MOVEMENTS] >=2,"MEDIUM MOVER",IIf([013_MK_S]![MOVEMENTS]< 1,"SLOW MOVER","0")))

[webisti]

Great it worked
Thanks Bob Fitz and others I just modified it to this : STATUS: IIf([MOVEMENTS]>=5,"FAST MOVER",IIf([MOVEMENTS]<5 And [MOVEMENTS]>=2,"MEDIUM MOVER",IIf([MOVEMENTS]<=1,"SLOW MOVER","0")))
and it works smoothly.

thanks guys

[webisti]

ONE MORE TIME PLS
now I want to use two "and" in one time like this code:
IIF( [SOH]=0 AND [STATUS]=FAST MOVER AND [STATUS]=MEDIUM MOVER,"PRIORITY",IFF( [SOH] =0 AND CRITICAL=X,"PRIORITY 2",IIF([SOH]=0 AND [PR QTY]>0,"PRIORITY,IIF( [SOH]=0 AND [LEAD TIME].90,PRIORITY,N/A)))
is that possible?

thanks again

[Bob Fitz]

I'm not really sure what you are trying to do exactly, but you could try this:
IIF([SOH]=0 AND [STATUS]="FAST MOVER" AND [STATUS]= "MEDIUM MOVER", "PRIORITY",IFF([SOH] =0 AND CRITICAL= "X", "PRIORITY 2",IIF([SOH]=0 AND [PR QTY]>0,"PRIORITY", IIF([SOH]=0 AND [LEAD TIME]= 90,PRIORITY,N/A)))

[jzwp11]

[STATUS]="FAST MOVER" AND [STATUS]= "MEDIUM MOVER",



I assume that a status can only be 1 value at a time so the above part of the expression will never be satisfied. Should it be OR rather than AND?

[webisti]

well based on the criteria of SOH=0 and is a fast or medium mover put priority,
soh =0 and critical =x, put priority
soh=0 and pr qty>0, put priority
soh=0 and lead time >90 put priority
that is all I want the iff to do.

[Bob Fitz]

OK. Does this do it:
IIF([SOH]=0 AND [STATUS]="FAST MOVER" OR [STATUS]= "MEDIUM MOVER", "PRIORITY",IFF([SOH] =0 AND CRITICAL= "X", "PRIORITY 2",IIF([SOH]=0 AND [PR QTY]>0,"PRIORITY", IIF([SOH]=0 AND [LEAD TIME]> 90,"PRIORITY","N/A")))