BI would like to be able to exclude weekend days at any time spent in the "On Hold" status. "On Hold" duration is a formula field defined as "durationInValue(Document.status__v,"On Hold"). Is it possible to exclude weekends in this calculation? If not, would it possible to create a new formula field that calculates the number of weekend days when a document is in "On Hold" status?
Please sign in to leave a comment.