We have a custom Service Request object and have following fields
Expected Resolution date
SLA Type can be calendar day or Business day.So we would like to report how many calendar/business days the service request exceeded the Expected Resolution date? So for those that were overdue, how many days late were they? And for those completed on time, how many days early were they ?
I want two saparate formula fields
SLA Missed days
SLA Met days
Below formula returns calendar days. I need to consider Business days if SLA Type = 'Business Days'
IF( IsClosed__c && (Expected_Resolution_Date__c > DateTimeClosed__c) && SLAType__c == 'Calendar Days', Expected_Resolution_Date__c - DateTimeClosed__c, 0 )