Exclude weekends from "On hold" duration

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? 


1 comment

  • Avatar
    Aaron E Official comment

    Hello Francesca,

    Unfortunately, it is not currently to exclude weekend days in time interval calculations and formulas.

    For more info on available functions and operators, please click here.



Please sign in to leave a comment.