0 Replies Latest reply: Jul 2, 2018 4:05 AM by haifeng zhao RSS

    Pick/Match concern

    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.

       

      Please see attached qvf for details.

       

      Best Regards,

      Haifeng