4 Replies Latest reply: Mar 20, 2014 6:28 AM by Michal Kwater RSS

    Count function

      Hello,

       

      I am an new member and I would like to set an expression with a count function.

       

      I have a data :

      NameCategorySubcategoryP131P232
      AZZZOther60,005,00352
      BZZZOther 170,00532,002565
      CXXXOther80,005,00345
      DXXXOther 190,0035,009035
      EZZZOther363,005,002535
      FXXXOther60,005,00352
      GZZZOther 170,00532,002565
      HXXXOther80,005,00345
      IZZZOther 190,0035,009035
      JXXXOther363,005,002535

       

      I would like to count a number of names which will be restricted by category 'XXX' and (P1+31 - P2 - 32) >0

      I also attached QV for support

       

      Another issue I have is count how many largest 'name' will make 80% (P1+31)  for subcategory.

       

      If someone could help I will be grateful .

       

      Many thanks in advance