Hi,
I am trying to create a view filter with case when nested in it.
It goes like this:
FILTER VBAP-FilteringField
CASE
WHEN COALESCE (Var1, ‘’) = ‘Open Order’ THEN = ‘Open Order’
WHEN COALESCE (Var1, ‘’) IN (‘Open Order’, ‘Missing Invoice’) THEN IN (‘Open Order’, ‘Missing Invoice’).
END
--
The issue is: in the beginning, when there is one value (‘Open Order’) resulted from the CASE WHEN statement, the filter works well. But when I expand the fomular, including the result as a list (‘Open Order’, ‘Missing Invoice’) and need to use the Word “IN” instead of “=” for filtering, it throws an err in the formular.
Any suggestion how I can work around this?
Thank you!