On my report I am using a Formula field to find the time it takes to deploy, from interest (date deployed - date interested).
Additionally, I would like to show the avg time to deployment....but using AVG on the formula field option only counts the records that a date in date deployed field.
How can I show the avg time to deployment on the report using a formula (or some other method)?
1 respuesta
Hi Ken,
Can you maybe send a screenshot to explain? Not too sure I understand. You have some rows where the formula returns null since one of the dates is not populated? Do you want those rows included or excluded from your average time to deployment?
The Avg function should take every row into account, and counts the blanks as 0 so if you have 4 rows, 2 that are blank and 2 that return a number (ie 2 and 3), the average would be calculated as (2+3)/4=1.25
If instead you want (2+3)/2, you'd need either another formula field (let's call it "DeployedCount) on the object or a row level formula on the report returning a number:
IF(OR(ISBLANK(Date1),ISBLANK(Date2)),0,1)
You can then create a summary formula on the report:
TimeToDeployFormula:SUM/DeployedCount:SUM
