Navigate to Reports > Saved Searches > All Saved Searches > New
- Click Transaction
- Search Title: Enter Title
- Select Criteria
- Click Results
- Select Formula (Numeric)
- Formula for SO Usage: CASE WHEN {transaction.type}=’Item Fulfillment’ THEN {transaction.quantity} else 0 END
- Formula for WO Usage: (CASE WHEN {transaction.type} IN (‘Work Order Issue’, ‘Work Order Completion’, ‘Assembly Build’) THEN {transaction.quantity} ELSE 0 END)