I have a button dropdown, where I've different inputs like:
EINDT
SLFDT
MENGE
NETPR
Separator : ,
I'm wrapping with:
start = '
end = '
My variable I'm writing into is changeFields
So I did a KPI where I'm using this case when:
CASE WHEN <%=ChangedFields%> = 'Lieferdatum (EINDT)' THEN 'EINDT'
WHEN <%=ChangedFields%> = 'Stat. Datum (SLFDT)' THEN 'SLFDT'
WHEN <%=ChangedFields%> = 'Preisaenderung (NETPR)' THEN 'NETPR'
WHEN <%=ChangedFields%> = 'Mengenaenderung (MENGE)' THEN 'MENGE'
END
THe problem is, when I'm using more than 1 input my CASE WHEN state the project doesn't work.
I tried it like:
WHEN <%=ChangedFields%> = 'Lieferdatum (EINDT),Stat. Datum (SLFDT)' THEN 'EINDT,SLFDT'
But this idea doesn't work. I also tried to do it with logic gates.
Does anyone have an idea how I can filter multiple inputs and check it in a case when function?