Hello,
I want this formula to return a value of 0 if the sum is a negative number. Essentially, if fulfillments are greater than receipts in the time period, rather than return a negative number I'd like a zero. Is this possible? I've been struggling with this for hours.
CASE WHEN DECODE({inventorylocation},{transaction.locationnohierarchy},1)= 1 AND ROUND({today}-{transaction.trandate}) BETWEEN 60 AND 120 THEN {transaction.quantity} *-1 ELSE 0 END
Thank you!
Jackie