8 Replies Latest reply: Feb 9, 2018 3:34 PM by Stefan Wühl RSS

    Help with Match function in if condition?

    Nicholas B

      Hi Everyone,

       

      Can you please help me to figure out what is wrong with below if condition?

       

      Somehow its not giving expected results.

       

      if(Type = 'XXX',if(Root <> 'Total', if(Match (Category,'8','1','2','33','35','3') and match(subtype,'20','21','23','20') ,

      if([Date] >= IntialDate and [Date]<=FinalDate and [Amount] >= InitialAmt and [Amount] <= FinalAmt , [Amount] * YYY , if(Type = 'XXX',if(Root = 'Total' , if([Date] >= IntialDate and [Date]<=FinalDate and [Amount] >= InitialAmt and [Amount] <= FinalAmt, [Amount] * YYY))))))  as AAAA

       

      Thanks