1 Reply Latest reply on Dec 16, 2016 12:48 PM by Stephen Rizzo

    Calculate average of days per region

    Alex Hartley

      Hello everyone,

       

      I have a list of projects. the row has the region and the project name. I have the start date of the project and the end date. I have a calculated field giving me the number of days it took to complete the project. There are a lot of projects that are missing dates so I filtered those out (start and end dates), removing the nulls. I am trying to get an average for the region of the total number projects, but only the ones that have the number of days calculated. Any suggestions on how to accomplish this? I know it sounds simple but for some reason I am not able to figure it out. Thanks