[kmullervy]

We are trying to find a formula to help us display how many business days a work order has been open. We want the count to start when the work order is released and stop counting when the quantity equals built. We currently are using a transaction search and we have this formula but it keeps counting even when the work order is completed.

FLOOR((trunc({today})-trunc({appliedtotransaction.datecreated}))/7)*5 + mod(trunc({today})-trunc({appliedtotransaction.datecreated}),7) – case when to_number(to_char({today},'D')) < to_number(to_char({appliedtotransaction.datecreate d},'D')) then 2 else 0 end
This is a cached copy. Click here to see the original post.

[Author]

Posts