Dealing with individual units for inventory

Hi Everyone, I am having an issue with an inventory app im developing. The inventory app takes in pallets(the pallets vary in size), the problem arises when someone needs an individual unit. Is there a way to have the pallets converted to individual units and then when someone needs an individual unit, have it subtracted it from the inventory?

You’re going to have to devise a formula to convert the pallets into the individual units. If the pallets contain cases of individual items, you could have a column takes in the number of cases on that particular pallet and then a workflow that updates the total inventory number based off the number of cases. Or something along those lines.