I want to calculate cycle time -difference between received date and closed date in days which includes only business days
Exclude weekends and public holidays
Using recordtype-new custom record field I wanna to achieve as I need to use in process hq reports
Thanks,
Priyadharshini. S
Discussion posts and replies are publicly visible
Use networkdays(receivedDate, closedDate, cons!PUBLIC_HOLIDAYS) in a sync-time custom record field - this works cleanly in Process HQ reports. For dynamic holidays, maintain the constant by periodically syncing it from your holiday table via a scheduled process.