The number 0 is not displayed in BAQ

Kinetic ERP
1

Hello everyone,

I am trying to create a report in BAQ showing shortages. But, the shortage did not appear in some lines, and when I checked, it was because 0 was not displayed in the on-hand column when the on-hand quantity was 0. It was displayed as just an empty column.
I have attached my Calculated Field that calculates the on hand. Could you please take a look and see what the problem is?
Thank you in advance!

image
image825×336 34.7 KB

image
image1502×783 164 KB

2

Try this, CASE WHEN SUM(PartBin.OnhandQty) IS NOT NULL THEN SUM(PartBin.OnhandQty ELSE 0 END

2 Likes
3

Unfortunately, even though I changed it with your tips, this issue still persists.

image
image1423×724 124 KB

image
image738×294 23.3 KB

4

change it to just parbin.onhandqty and show us the results

1 Like
5

I tried changing this but the result was the same.

image
image1318×612 96.4 KB

6

I just created a new calculation SQL to convert null to the number 0.
Thank you to everyone who helped.

image
image1324×744 134 KB

7

image
image723×505 17.8 KB

I think u must create the Calculation Field to convert the null using Case when.

1 Like
8

Yes. I already solved this issue that way.

9

yes, I wanted it without the sum, but the whole point was to see if it was null :wink:

Glad ya got it!

10

Another way to do it would have been to use the ISNULL function.

ISNULL( Sum(ShipDtl.OurInventoryShipQty), 0 )