Goal is to create a Saved Search to compute Safety Stock Level. Trying to combine two formulas and unable to determine how it should be constructed. I created two test searches to verify my formulas work, as follows:
Search 1 (Item Search): Avg Qty Sold/Day - Summary Type: Average, Function: Round
using formula:
To_char({transaction.quantity}/{custitem_nsacs_uomconvrate}/182.5)
Search 2 (Transaction Search): Avg Days to Receive - Summary Type: Sum
using formula:
CASE WHEN {recordtype}='purchaseorder' THEN {fulfillingtransaction.trandate}-{trandate} ELSE NULL END + 14
These work great individually. However, I wish to combine these two saved searches into one and cannot get it to work. Still fairly new to this. Cannot get 2nd Formula to work in an Item Search.
My formula should look something like this: (1st Formula) * (2nd Formula + 14)
I created a new Item search as follows: (named Compute Safety Stock Level)
CRITERIA
RESULTS
How do I get an Item based formula and a Transaction based formula to work correctly in a single Saved Search (Item?/Transaction?) to get the proper result?