Formula Query for Average Duration?
I am trying to use a formula query to calculate the average duration an activity is open. With a little help, I have a query to get the Count and I tried to use that query in a SumValues function to ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendThe duration is probably in some units like seconds, so there are a lot of them. I suggest that you make a numeric formula field field representing the # of hours such as ToHours([My duration field])
Change your query to query against that pure numeric field and you will know that the result is an hours. If in fact the length of your activity is really in days then you could convert the duration into days instead of hours and add up the number of days.
------------------------------
Mark Shnier (YQC)
[email protected]
------------------------------
Change your query to query against that pure numeric field and you will know that the result is an hours. If in fact the length of your activity is really in days then you could convert the duration into days instead of hours and add up the number of days.
------------------------------
Mark Shnier (YQC)
[email protected]
------------------------------