6 Replies Latest reply: Mar 21, 2013 8:36 PM by Donna Aranzanso RSS

    Calendar Input Box

      Hi All,

       

      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:

      StatusSiteCurrent 1-30 Days Over 30 Days Over 60 Days Over 90 Days Over 150 Days Over 240 Days Total
      Open






















      Released










      Grand Total








      the formula

      = date input - Shipmentdate

       

      current = <0

      1-30days = >0<=30

      Over 30days = >30<=60

      .. and so on

       

       

      Please see attached file.

       

       

      Thanks