Hello, when creating a baq where it shows our “FreeStock” in both UK and PL we run a few calculated fields such as On Hand - Demand etc in some occasions this will end up resulting in negative free stock is there anyway in the calculated field we can add where free stock = negative change to 0 ?
In your calculated field put something like
CASE WHEN OnHand-Demand < 0 THEN 0 ELSE OnHand-Demand END
7 Likes