Best Of

@JackB116 you are on the right track. When you want to look at multiple conditions, you want to use 'and'. So you would just replace 'then when' with 'and'

CASE when `Invoiced Month` in ('10', '11', '12') 

and 'Invoiced Year' = '2022'

and `Sales Order Type` in ('PRE ORDER', 'PRE ORDER POST DEADLINE') then `Row Net` else 0 end