I have a custom search where I want a Case stateme...
# generalj
Joe Morreale
08/15/2022, 7:55 PMI have a custom search where I want a Case statement that require 2 things to be correct. Currently I have sum(case when {custbody_make} != 'Yamaha' then 0 else 1 end). I want to also add 1 additional criteria that the {custobody_program} is New. I cant seem to get it to work. I just get an error
m
Mike
08/15/2022, 8:17 PMYou should use AND/OR with your criteria
Mike
08/15/2022, 8:18 PMwhen {custbody_make} != ‘Yamaha’ AND {custbody.year} = ‘1999’ then 0
Mike
08/15/2022, 8:18 PMAt least, I think that’s what you want…
Mike
08/15/2022, 8:19 PMsorry, just reread your question.. updated answer to be….
when {custbody_make} != ‘Yamaha’ AND {custbody.program} = ‘New’ then 0
j
Joe Morreale
08/16/2022, 3:45 PMThanks for the response. I will try it now
Joe Morreale
08/16/2022, 3:47 PMsum(case when {custbody_make} != ‘Yamaha’ AND {custbody_program} = ‘New’ then 0 else 1 end)
Joe Morreale
08/16/2022, 3:47 PMSo it should look like the above right?
Joe Morreale
08/16/2022, 3:53 PMThat seemed to work. Thank you again
Joe Morreale
08/16/2022, 4:23 PMhmmm for some reason it give me a number that is all Yamaha, but isnt taking into account the program being "New" also
Joe Morreale
08/16/2022, 4:24 PMI have the summary type as maximum
4 Views