Hello!
I am using the formula below to calculate kit availability:
=Floor((IsNull( [INSiteStatus.QtyOnHand], 0 ) / IIF( [INKitSpecStkDet.DfltCompQty] >0, [INKitSpecStkDet.DfltCompQty],1 )))
I have a parameter for InventoryCD so user can search for the inventory ID if needed.
The GI would run fine and there are records that show up, however, every time I click to search for an inventory ID, I receive the following error:
I’m not sure I understand the error and what I need to change in the formula. Any help would be appreciated!
Another note: originally the formula looks like: =Floor((IsNull( [INSiteStatus.QtyAvail], 0 ) / IsNull( [INKitSpecStkDet.DfltCompQty], 1 )))
This formula does not give me the above error, instead it gives a different error saying “Divide by zero error encountered.”
