xDI

Hello Matthew,

IF statement is not present but you can use CASE WHEN instead of IF which helps you to achieve your use case, also CASE function is present in the documentation.

For sample-

CASE
    WHEN condition_1 THEN result_1
    ...
    WHEN condition_n THEN result_n
    [ELSE default_result]
END

hello Matthew,

here would be the SQL Server compatible formula. I don't feel it is that much complex but hopefully this works anyways.

CASE 
  WHEN 
    L2 <> '' OR M2 <> '' OR N2 <> '' OR O2 <> '' OR P2 <> '' OR Q2 <> '' OR 
    R2 <> '' OR S2 <> '' OR T2 <> '' OR U2 <> '' OR V2 <> '' OR W2 <> '' OR 
    X2 <> '' OR Y2 <> '' OR Z2 <> ''
  THEN
    CASE 
      WHEN 
        (
          (M2 IN ('Label', 'Shrink Band', 'Other Material', 'Sticker') AND 
           L2 <> '' AND O2 <> '' AND P2 <> '' AND Q2 <> '' AND R2 <> '' AND S2 <> '')
          OR
          (M2 IN ('FG SKU', 'WIP SKU') AND 
           L2 <> '' AND O2 <> '' AND P2 <> '' AND Q2 <> '' AND R2 <> '' AND S2 <> '' AND W2 <> '' AND X2 <> '')
        )
      THEN
        CASE 
          WHEN S2 = 'New' THEN 'Complete'
          WHEN T2 <> '' THEN 'Complete'
          ELSE 'Incomplete'
        END
      ELSE 'Incomplete'
    END
  ELSE ''
END

  Stéphanie.