2 Replies Latest reply: Feb 23, 2018 3:29 AM by Yeo Poh sai RSS

    =if(Match(Year_V, '2018')  ,[Opportunity Name]) How to add one more condition ?

    Yeo Poh sai

      Hi All

       

      I have below expression at dimension it work fine :-

       

       

      =if(Match(Year_V,

       

      '2018')

      ,[Opportunity Name])

       

       

       

      I need to add one more condition , that is field name Probability > 0 :-

       

       

      =if(Match

       

      (Year_V,'2018'),

       

      (Probability,'>0')

       

      ,[Opportunity Name])

       

       

       

      =if(Match

       

      (Year_V,'2018' Probability,'>0'),

      [Opportunity Name])

       

       

      But it fall to work , can some one advise me where i go wrong ?

       

      Paul