7 Replies Latest reply on Aug 25, 2015 1:00 PM by drew k

    Table calculation across a category

    drew k

      I have a calculated field that displays the difference between the current date and the previous for a list of dates. However, I have multiple categories that each contain their own dates and I want to be able to compute average differences for each separate category. So, I want this difference counter to start over when it comes to a new category. I've circled the places where the counter should reset to 0.

      Sheet 1.jpg

       

      I've also attached the workbook containing this worksheet. Any ideas on how I can achieve my desired result? Or perhaps if there is a better tool suited for this problem?

       

      Thanks