6 Replies Latest reply: Mar 2, 2016 9:18 AM by Avishai Zonnenberg RSS

    count if

    Avishai Zonnenberg

      i want to count the number of lines where there is a difference between inventory and counted

       

      sample data:

      item namedateinventoryconted
      aaa22/8/2015154
      bbb13/7/20157065

       

      one time just to count the number of lines where there is a difference between inventory and counted

      another value is the number of lines where inventory was larger

      another value is the number of lines where inventoty was smaller