1. SuiteAnalytics
  2. Search
  3. Formulas in Searches
  4. Search Formula Examples and Tips
  5. Calculating Time Taken to Approve Orders

Calculating Time Taken to Approve Orders

You can use formulas in searches to calculate the time taken to approve orders.

To use a formula for calculating the time taken to approve orders:

  1. Create a Transaction search, with filters of Type is Sales Order, Main Line is true, System Notes : Field is Document Status, and System Notes : New Value is Pending Fulfillment.

  2. Add a Formula(Numeric) results column with the formula {systemnotes.date}-{datecreated}. You can add a Custom Label that indicates this calculation is the time taken to approve each order.

Related Topics

General Notices