I'm trying to use a decode function for an inventory location that is a child location, but I can't get it to work (works fine with parent locations). Does anyone know what the proper format would be for the formula? This is the formula that works: DECODE({inventorylocation}, 'Vancouver Warehouse', {locationquantityonhand}), but I need to get the location on hand for a sublocation of Vancouver Warehouse instead (Vancouver Warehouse : Inbound Hold).