This content has been marked as final. Show 3 replies
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.