3 Replies Latest reply: Aug 31, 2016 6:06 AM by Christian Wylezol RSS

    Input Box Sort Order with unique Values

    Christian Wylezol

      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