Forum Discussion
SLA Calculation based on multiple criteria
Hi Community, I really need help in finding the best approach to come to a solution to calculate the DATE DIFF days for each line/ #ref. Calculate average of Date Diff days between the fol...
Anonymous I looked at your data and not sure what you mean #ref in your post , like when #ref selected? Can you in sample excel sheet put a column with expected result.
Hi parry2k
Exactly, the main objective is to get the number of "REF_ID" considering the following:
- If selected Date_Presented is < beginning of the quarter in which #ref selected is, do not consider
- If selected Date_Requested is > selected month in which #ref selected is, do not consider
- If (Date_Requested > (end of the month - 21 days) & (Date_Presented > End of the month)) , do not consider
Can you help me please?
Thank you