I have a client that is on CRM2015, but Update 1 has not been applied yet. I need to compute the average value based on the following criteria: Find the average number of days it takes an Account Manager to close a project.
So...to break it down:
Project 1: takes 5 days
Project 2: takes 15 days
Project 3: takes 12 days
Project 4: takes 7 days
Logically, I should add up total days and then divide by the number of projects to get my average.
29 days divided by 4 = 7.25 is the avg of these numbers
I have created rollup fields in the User record for both -- Total Completed Projects (using whole number) and Total Days to Complete (which is a whole number duration field). All is good up to this point...
Now if I use a calculated field to divide Total Days to Complete by the Number of Projects, I should get my average value. Unfortunately I have found that since Total Days to Complete is a duration field it cannot be used in the calculation.
Any advice on how I can accomplish this task would be great.
Thank you.
Stacey
*This post is locked for comments
I have the same question (0)
