This content has been marked as final. Show 6 replies
I need to make a chart counting the no. of records that is outstading based on the calendar input box.
I want the chart looks like this:
|Status||Site||Current||1-30 Days||Over 30 Days||Over 60 Days||Over 90 Days||Over 150 Days||Over 240 Days||Total|
= date input - Shipmentdate
current = <0
1-30days = >0<=30
Over 30days = >30<=60
.. and so on
Please see attached file.