Average (Actual Duration) on Reports

Question

Hi,I have a "text-multiple choice" field with drop down options "revise, reuse, modify, new". I am pulling up a report grouped based on the above options. The report shows up only the "total" of the "Actual Duration" for each group. Is there a way, I can make the report to show "averages" instead of "total" on the "Actual Duration". See screen shot:The report customization gives me only option to "hide all total/averages" (and, not to show "averages")I would like to see the result of on an average how many days it takes to finish a "new or revised, or modify" project.Please help. Thanks.

quickbasecoachd · Answer

Easy,  Edit the field properties for Actual Duration to uncheck show Totals and to check off To show Averages.

evanmartinez · Answer

Hi Kingsly,It might seem a bit counter-intuitive when you are on a report but that option to show an Average or a Total is controlled on the field settings. If you open up the field settings for Actual Duration under the display options you will find the checkbox to 'Display an average of this field in reports'. Enabling this will cause the averages to show on report, then you can also disable the Totals if&nbsp; you would like. I hope this information is helpful.&nbsp;

kingslysamuel1 · Answer

The "Actual Duration" is a "numeric-formula field" to show actual days that it took to finish the project from start to complete. And, I don't see the option you are saying in the field properties, Mark.

kingslysamuel1 · Answer

Ignore me, found it. Thank you.

kingslysamuel1 · Answer

yes, found it. Thank you both it is just above the formula bar.

Forum Discussion

Average (Actual Duration) on Reports

Related Content

Average daily active employees calculation

Percentages are Sums instead of Averages on the Total and Averages Rows

Duration Fields with Pipelines

Create a formula duration over 5 years

Duration Formula