2 Replies Latest reply on May 1, 2018 11:42 PM by Samuel Dharmaraj Thiagarajan

    Warehouse data

    Samuel Dharmaraj Thiagarajan

      I have a list of warehouse data. In this data, the material numbers are listed in the appropriate warehouse location and name. The material has an incoming warehouse date which means when did this particular material reach the warehouse.

       

      Now, I want to have a data representation under this format,

      Warehouse Location, Warehouse Name, Total no. of materials in warehouse, No. of materials present more than 60 days, % of tools present more than 60 days.

       

      An example,

       

      Warehouse Location
      Warehouse Name
      Total no. of materials in warehouse
      No. of materials present more than 60 days
      % of materials present more than 60 days
      0000Asset Creation Warehouse11100%

       

      Can you please help me with this. I'm new to this application.

        • 1. Re: Warehouse data
          Jim Dehner

          good morning

          please see attached

           

          is this what you expected

           

           

          in each warehouse

           

           

          Jim

           

          If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

          • 2. Re: Warehouse data
            Samuel Dharmaraj Thiagarajan

            Dear Jim,

             

            The data shown after the calculation is incorrect.

            For example,

            Warehouse : 1133

            Warehouse Name : RTC - Scrap House

            Total no. of materials : 37

            No. of materials present for more than 60 days : 36

            Percent of materials present for more than 60 days : 97%

             

            But according to your calculation, it is showing 17. And how is the both the total no. of materials and the materials present more than 60 days column values are same and also the percentage is 100 for all?

             

            Please refer to the example.