3 Replies Latest reply: Nov 19, 2016 2:04 PM by Adam Jankowski RSS

    Pick(Match()) full string in the Set Analysis

    Adam Jankowski

      Hello,

       

      Before I prepare the whole file to show you what is the issue, I write it here:
      I've prepare the variable like these:

      vChoice:

      pick(match($1, 'Veges','Fruits')

      '[Veges] ={"Cucumber"}',

      '[Fruits] = {"Bananas"}'

      )

      Then if I put the variable into the Set Analysis according to the official documents, only errors pops up:
      =

      =SUM({$ < $(vChoice("Veges")) >} [Spend]) it's no working and got this error 'Error: Error in set modifier expression'

       

      Thanks in advance,
      Adam