PartBin - Listing Non Whole Numbers Only

Kinetic ERP
1

I have a BAQ that pulls
Part.partnum
part.ium
part.partdesc
Sum(Partbin.onhandqty
Filter on ium = EA

Need a listing of qty on hand that is not a whole number.
Ideas?

2

Use modulo

image

e: Actually I guess using FLOOR() would be even simpler.

YourQtyColumn = FLOOR(YourQuantityColumn) tells you it’s a whole number.

1 Like
3

Wouldn’t floor just return the integer? Also, I recall it doing weird things with rounding sometimes.

I’d go with your original suggestion: adding Partbin.OnHandQty mod 1 <> 0 to the where clause will list out any bins with decimal qtys.

4

I believe they accomplish the same thing. Which one is simpler is a matter of opinion I suppose. :slight_smile:

FLOOR is supposed to ‘Return the largest integer value that is equal to or less than’ your number. FLOOR(2.99999999) = 2, etc

So where PartBin.OnhandQty <> FLOOR(PartBin.OnHandQty) should return the same results as Partbin.OnHandQty mod 1 <> 0