10 Replies Latest reply: Feb 21, 2017 8:03 AM by Marcus Sommer RSS

    Default value for pick match

    Jurien Groot

      Hi,

       

      I am using a pick and match formula with a dimension (not a variable) and I'd like to show a default value if no value is picked.

       

      $(=Pick(Match((Grouping1),'Option1',

      'Option2')

      ,'[Option1]'

      ,'[Option2]'

      ))

       

      I thought of something like:

       

      if(Count(Grouping1)=1, $(=Pick(Match((Grouping1),'Option1',

      'Option2')

      ,'[Option1]'

      ,'[Option2]'

      )),Option1)

       

      Anyone knows the right syntax for it?