Skip to main content

IF [item] = ‘item1’ AND

([Price] >= 24.00 AND [Price] <= 39.10) THEN 'group1'

ELSEIF [item] = ‘item1 ’AND ([Price] >= 40  AND [Price] <= 50) THEN 'group2'

ELSEIF [item] = ‘item1’ AND ([Price]   >= 50 AND [Price] <= 60 ) THEN 'group3'

ELSEIF [Price] == 66 THEN  'group3'

END

 

in the above if statment in the range 50-60 there are three other values such as 59a,59b and 59c.

As price is a numeric field these values are getting ignore.

I tried using functions such as left and contains, error cannot use float values with teh string functions is displayed.

any suggestions on how can i handle this

1 answer
  1. Apr 27, 2020, 1:28 PM

    Can you provide some sample data?

     

    I'm thinking that, perhaps, you could use REGEX to remove non-numeric characters, then convert the string to a number, but I'm not sure without seeing some real data.

0/9000