2 Replies Latest reply: Jul 2, 2018 2:31 AM by haifeng zhao RSS

    Pick/ Match Concerns

    haifeng zhao

      Hi Folks,

       

      Concerns regarding Pick match need your help.

       

      Now we faced the challenge, See details as below:

      Dimension:

      Pick(match(GetFieldSelections(Periods),'Qtr','MAT','Monthly','YTD'

      ),

      YearQtr,[Y e a r],YearMonth,Pastfield

      )

      Note:Passfield not associated with master table, other three dimension associated.

      Measure:

      Pick(match(GetFieldSelections(Periods),'MAT','Qtr','Monthly','YTD'),
      num(sum(1),'#,##0'),
      sum(2),
      sum(3),
      sum(4)).

       

      In current case, we get the result as 1224, not 4; just we used Pastfield only, we can get the correct num 4, so this is my concern, why we cant get the correct num? Thanks in advance.

       

      Best Regards,

      Haifeng