1 Reply Latest reply: Apr 25, 2013 2:28 PM by Gysbert Wassenaar RSS

    Help in expression

    Abey Chandy

      Hi,

       

      My data looks like this. The requirement is to count the customers that are deactivated (having status as "D"). In the example below - my count of deactivated customers  should return 1 - i.e. CustC. Because only for that customer the status is D for all dates. Can this be done as an expression?

      QV_Data.png

       

      Thanks,

      Abey