Skip to main content
I have a formula on the ACCOUNT record that measures (DATE DEPLOYED - DATE INTERESTED) as DEPLOYMENT TIME.

 

In my report, I have a formula that counts those accounts that have been deployed and places a 1 in the field using IF(ISBLANK(Service__c.Deployment_Config_Completed__c),null,1)

 

Im then using Summary Formulas as columns in the report to determine AVG, MIN, and MAX deployment times.  I'm having a problem with MIN as it sees nulls/zeros for those not yet fully deployed and counts 0 as the MIN deployment time (Service__c.Deployment_Time__c:MIN)

 

How to Accurately Find Minimum Time in Report
2 件の回答
0/9000