0

I am currently calculating the difference between created date and modified date in my SharePoint custom list.

Is it possible to also calculate the average of the # of days, totalled by month?

I am using Sharepoint 2013 on-premise with SharePoint Designer.

0

SharePoint does not natively provide rollup totals for calculated columns, but you do have some options on-prem.

You can get the total number of days between the two dates for each row with the following calculated column formula:

=DATEDIF(Modified,Created,"d")

To emulate a rollup value, you will need to do some JavaScript trickery. This article provides a how-to create a javascript-based calculated "Total" column. You would of course need to modify the line of code the sets the var TotalSum= to calculate your average instead of a sum.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.