OK- Just with the second formula which you added parens to, the issue is that instead of returning the correct amount of partial cases it always returns just the number one. The issue only occurs when there are two lot numbers for one order. I am using Crystal Reports with ACCTivate! software...
Two issues: 1) It tells me "a string is required here: at the end of the if statement (where the=0 is).
totext (Truncate (if {Product.AlternateUnitConversionFactor} = 0 then 0
else {OrderDetailLot.Quantity} / {Product.AlternateUnitConversionFactor}), 0)
+ "cs" + " " + "/" +...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.