0 Replies Latest reply: Oct 25, 2016 5:32 AM by Jaydeep Sanghavi RSS

    Help required for Pick Match function withing If else

    Jaydeep Sanghavi

      my Second Pick is not getting calculated after applying filter

       

      I am trying to put all numbers Manually Product wise.

       

      So when i apply filter on [TerritoryLevel4] ='S_UKI' it still shows value for [TerritoryLevel3]='S_EMEA'

       

      Please help

      E.g.

       

      If([TerritoryLevel3]='S_EMEA',(Pick(Match([Product Sub Category],'A','B','C',

      'D','E','F','G','H','I','J','K','L','M','N')+1,

      7087645,3100720,7239302,3495407,11574307,1767474,5451370,4072107,9562232,3658490,4785699,322131,6208621,5825034,0))/1000000,

       

      If([TerritoryLevel4] ='S_UKI',

      (Pick(Match([Product Sub Category],'A','B','C',

      'D','E','F','G','H','I','J','K','L','M','N')+1,

      '1774348','655502','1518050','517787','2101909','-9183','3072889','853903','1993201','1183086','2501750','37068','1279540','1723476','0')/1000000),''))