I have a BAQ that looks for inventory onhand and performs a calculation. But when there is no bin, it returns NULL. I want to return zero.
I searched here but none of the answers are working. One answer said to use IS NULL(field,0) but that did not pass the syntax test.