I think you can do it with this formula case when ((to_char(to_date({trandate}),‘YY’)) = ‘18’) then {amount} else 0 end