Counting space-separated variable

[Sebastian_Dec]

Hi, I have a problem.

I have input that contains variable iCodes:

in input:

5906764646995 5907637313075 5902627094491

This is a list of EAN ( European Article Number ) codes separated only by spaces

I want to count this EAN's on KPI:

count({< kod_ean = {$(iCodes)}>} kod_ean)

But I have error:

I try to solve this somehow but non of my code work.

[Or · Accepted solution]

You seem to be missing the string quotes, since the value isn't numeric (it contains whitespaces).

If that's meant to be multiple separate values, you'd want to comma-separate them.

[Sebastian_Dec · Accepted solution]

Ok, @Or , thanks for suggestions its works!

I make new variable: iCodesFormatted that have definition:

=chr(34) & replace(iCodes, ' ', chr(34) & ',' & chr(34)) & chr(34)

The value is: "5906764646995","5907637313075","5902627094491"

And KPI count  number of codes that are searched

count({< kod_ean = {$(iCodesFormatted)}>} distinct kod_ean)