Null table returning grey checkbox

Epicor ERP 10
1

I am checking the shipped status of a project by looking at the OrderRel table in a subquery of a BAQ.
This is the code I am using for the calculated field. the problem is that when a project does not have any sales orders, it is returning a greyed out checkbox that is set to true.

case when Sum(OrderRel.OurReqQty) IS NULL then 0 else (case when Sum(OrderRel.OurReqQty)<=Sum(OrderRel.OurJobShippedQty) then 1 else 0 end) end

I’m not sure if this is an Epicor issue or a SQL issue but does anyone know how I would replace those weird halfway values with a value of false?

here’s a picture of the grey checkbox

2

The checkbox has 3 states, true, false, or indeterminate. The grey check means it’s neither true nor false.
can you try ‘TRUE’ and ‘FALSE’ rather than 1 or 0 and see if that changes the behavior?

4

I ended up calculating the sums of the 2 fields separately and then bringing them into a higher level query to compare them.
When I did that it fixed it for all cases but one, which was an odd case anyway because it was missing a lot of other stuff as well.