I have a calculated column with specific formula, which returns single number. The number represnts number of days between task created and task closed. I want to display an average counter to this task. When I go to "modify this view" then "totals" my column is not displayed there . How do I add average counter to it?

1 Answer 1


You cannot use a calculated column for totals within a view. You could use a workflow to move the information over to a numeric field and then choose average within your views for that column.

Your formula could be:

=DATEDIF(Date1,[Date 2],"d")

This would calculate the number of days between the two dates.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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