Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a Problem with an Input Box.
I created one for Year and one for Period. Now I Need one for month.
So far so good. Now the Problem. I want to have the month from January to December (but only once in the list)
In the Variables-Section I put in listed values the following Expression.
=Concat( {1} DISTINCT coda_month, ';' , coda_period)
With this Expression I get January twice (Period 0 and 1 are Jan) and December three times (Periods 12 to 14 are Dec).
Does someone has an idea of solving this?
Thanks in advance
Chris
or this
=Concat(DISTINCT {1<coda_period = {'*'} - {0, 13, 14}>} coda_month, ';' , coda_period)
How about if you do this:
=Concat(DISTINCT {1<coda_period -= {0, 13, 14}>} coda_month, ';' , coda_period)
or this
=Concat(DISTINCT {1<coda_period = {'*'} - {0, 13, 14}>} coda_month, ';' , coda_period)
Hi Sunny,
very much thanks again. It works.