1) For inventory, I'm trying to get the sum total of all inventory in warehouses where warehouse number in (100,200,300). Additionally, my formula for getting the inventory is: IM_ItemWarehouse.QuantityOnHand -IM_ItemWarehouse.QuantityOnPurchaseOrder…