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.


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



      I'm trying :-


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