10 Replies Latest reply: Mar 13, 2016 9:19 PM by Saran De RSS

    how can i put if, then count in the one expression?

    Laura Castagna

      Hi ,

      I want to achieve the following but am not having any luck.  Any help appreciated:-

       

      I want to count(green) all accountNo. or lines where the Member = 'Yes', and the AccountNo and productClassifation are the same.

         

      Count
      4
      AccountNoAccountNameMemberProductNumberProductClassification
      2500Red SoxYes503650RedBox
      2500Lost and FoundYes502144Glass
      2750Blue BearsNo502014RedBike
      2700Green ToadsYes502260RedDoor
      2700Green ToadsYes502874RedDoor

       

       

      I'm trying :-

       

      =if(IsMember='Yes',count(DISTINCT[AccountNo]&[AccountName]&[ProductClassificationSummary]) )