4 Replies Latest reply: Oct 14, 2018 2:14 AM by Simbai Mhuka RSS

    Expression Query

    Simbai Mhuka
      DateAvailabilityStatusVendorTechID
      1/01/20180.99BHuawei2GA0001
      2/02/20180.98ASamsung3GA0002
      25/01/20180.999BHuawei3GA0003
      4/04/20180.97AHuawei2GA0004
      7/04/20180.975ASamsung2GA0005
      25/04/20180.99BSamsung2GA0006

       

      Hie Guys. I would like to write an expression that will enable me to  count the number of 'ID's by 'Tech' and 'Vendor' which satisfy the condition that Count (Status = 'A' ) => 14 per month.     

       

      Kindly Assist!!!

       

      Thank you.