3 Replies Latest reply on Jun 9, 2018 6:05 AM by Jim Dehner

    calculation for the age of the ticket

    srikanth akula

      Hi,

       

      I want to calculate the age of the ticket. I have used three filters which should be across all the sheets based on those filter I need to calculate the age of the ticket(number of records).

      I have done the calculation for >5 days, >30 days and >90+ days which I feel is wrong.

      Attached the workbook. Could some help me out with the calculation.

       

       

      Thanks,

      Srikanth