3 Replies Latest reply: Sep 1, 2016 10:42 AM by Omotayo Olokede RSS

    Aging Item Report

    Omotayo Olokede

      Good day everyone,

       

           Let me start by thanking everyone for the last support rendered towards me. My boss really liked and enjoyed the Dashboard.

           but i had a small challenge, we have a lot of items in our inventory and i want a report to show for AGING items(i.e Items that are more than 30 days in stock, 60 days in stock, 90 days in stock).

       

      i don't know how to go about it.

       

      i have this in mind: If (RCVD_DATE < (30), count(OH_QTY))

      But mere looking at this line of code i am sure it will not work, which i tried and it doesn't.

       

      Please i need assistance on this.

      How do i go about this.