CASE WHEN MAX({item.quantityonhand}) - (CASE WHEN ...
# generali
iSuite
04/15/2019, 3:36 PMCASE WHEN MAX({item.quantityonhand}) - (CASE WHEN (TRUNC({today}) - {trandate}) < 30 THEN {quantity} ELSE 0 END) < 1000 THEN 777 ELSE 888 END
💯 3
1000 1
iSuite
04/15/2019, 3:36 PM