Test

[Phil_Seamark · Accepted solution]

Hi @StevesHelp

Change your & to be && instead.  

& will try to concatinate

&& is the logical AND test

Consider using this format too:

Stock or S.O. or DOTCOM = 
SWITCH(
    TRUE() ,
    mid(format('omsid sales'[PONUM], "############"), 3,1)="9" && 'OMSID Sales'[shipno]="HD8119", "Stock DOTCOM",
    MID(FORMAT('OMSID Sales'[ponum], "############"), 3,1)<>"9" && 'OMSID Sales'[shipno]="HD8119", "S.O. DOTCOM",
    mid(format('omsid sales'[PONUM], "############"), 3,1)="9" && 'OMSID Sales'[shipno]<>"HD8119", "Stock",
    MID(FORMAT('OMSID Sales'[ponum], "############"), 3,1)<>"9" && 'OMSID Sales'[shipno]<>"HD8119", "S.O.",
    -- ELSE--
    "OTHER")