Skip to main content

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?

Hi @1460047082 ,

 

Try by using 'LIKE' instead of the '=' sign.

 

Also for your case 'IN' or 'IN_LIKE' might work.


Reply