Returning all the same value.

Liv_Stearns
Liv_Stearns Member
edited February 6 in Beast Mode

I got this code to work, well kind of. Its only returning 110

CASE
When Actual bid 2 >2700 THEN 120
When (model LIKE '%250%' OR '%2500%' OR '%350%' OR '%3500%') THEN 110
ELSE 110
END

Tried this

CASE
When Actual bid 2 >2700 AND model LIKE '%250%' OR '%2500%' OR '%350%' OR '%3500%' THEN 110
when 'actual bid 2' <=2700 then 110
When (model LIKE '%250%' OR '%2500%' OR '%350%' OR '%3500%') THEN 110
ELSE 120
END

tried a few others as well and can't seem to get it to work. I made verifier columns to make sure the individual segments work and they do but I can't get them to go together into one.

UPDATE: The portion not working currently is as follows
WHEN

`YMM`IN ('%F 250%')

OR 'YMM' IN ('%F-250%')
OR 'YMM' IN ('%F250%')
OR 'YMM' IN ('%F-350%')
OR 'YMM' IN ('%F350%')
OR 'YMM' IN ('%F 350%')
OR 'YMM' IN ('%F 250%')
OR 'YMM' IN ('%3500%')
OR 'YMM' IN ('%2500%')
THEN 110

I'm trying to find YMM that contains those values. I made a second column with 1/0 output and got nothing but 0's on all vehicles. Even those that contain these values.

Best Answer

  • MichelleH
    MichelleH Coach
    Answer ✓

    @Liv_Stearns When trying to match multiple patterns, you will need to repeat the LIKE statement each time. So instead of this:

    When (`model` LIKE '%250%' OR '%2500%' OR '%350%' OR '%3500%') THEN 110
    

    You will need to structure your conditions like this:

    When (`model` LIKE '%250%' OR `model` LIKE  '%2500%' OR `model` LIKE '%350%' OR `model` LIKE '%3500%') THEN 110
    

Answers

  • MichelleH
    MichelleH Coach
    Answer ✓

    @Liv_Stearns When trying to match multiple patterns, you will need to repeat the LIKE statement each time. So instead of this:

    When (`model` LIKE '%250%' OR '%2500%' OR '%350%' OR '%3500%') THEN 110
    

    You will need to structure your conditions like this:

    When (`model` LIKE '%250%' OR `model` LIKE  '%2500%' OR `model` LIKE '%350%' OR `model` LIKE '%3500%') THEN 110