Discussions
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
Item Search with complex formula based on transactions.
I have a saved ITEM search with the following formula:
Formula(Numeric):
(CASE WHEN SUM(CASE WHEN ({transaction.type} = 'Order Reservation') THEN (CASE WHEN ({transaction.type} = 'Order Reservation' AND {transaction.status} = 'Approved' AND {transaction.saleschannel} = 'DTC') THEN ({transaction.quantitycommitted}-{transaction.quantitydemandallocated}) ELSE 0 END)ELSE 0 END)+ MAX(NVL({locationquantityavailable},0)) +MAX(0) <0 THEN 0 ELSE (SUM(CASE WHEN ({transaction.type} = 'Order Reservation') THEN (CASE WHEN ({transaction.type} = 'Order Reservation' AND {transaction.status} = 'Approved' AND {transaction.saleschannel} = 'DTC') THEN ({transaction.quantitycommitted}-{transaction.quantitydemandallocated}) ELSE 0 END)ELSE 0 END)+ MAX(NVL({locationquantityavailable},0)) +MAX(0)) END)-{custitemdtcavailqty}
Summary type = Maximum
This returns the correct values, so the formula is OK. However, I really only want to see values if they are not equal to zero. When I put this formula in as criteria instead of a result, netsuite gives an error: "