3 Replies Latest reply on Apr 15, 2016 4:42 AM by Kevin Sullivan

    Average for first 5 days or 12 days....

    Kevin Sullivan

      I am trying to make everyone's results equal based on the day number from their first "Real Date".  So in my quick I filter I want to be able to select the first 5 days, 7 days, 12 days, any amount and get the average for each person across their first 5, 7, or 12 days from when they first started.  I would also like to be able to say on day 17 for everyone they averaged....

       

      I have been trying this with an INDEX().  I can get it to count but I cant get past that to make averages.

       

      Thanks,

       

      Kevin