In an item saved search, how can I get the value per unit based on unit of measure with multiple quantities?

AI generated answer (using internal Slack threads):

In order to get the value per unit based on unit of measure with multiple quantities in an item saved search, you can use a formula field in your saved search. Here's a general approach: 1. Create a custom field on the item record to store the conversion rate. This field will hold the conversion rate from the base unit to the other unit of measure (UOM). For example, if you buy an item as a carton of 6, but sell it as individual units, the conversion rate would be 6. 2. In your saved search, add a formula field that calculates the price per unit. The formula would be something like this:

CASE WHEN {uom} != 'base unit' THEN {quantity}/{conversion rate field} ELSE {quantity} END

. This formula checks if the UOM is not the base unit, and if it's not, it divides the quantity by the conversion rate to get the quantity in base units. If the UOM is the base unit, it just uses the quantity as is. 3. To get the price per unit, you can then divide the total price by the quantity in base units. Please note that this approach assumes that you have a relatively simple UOM model, where items are transacted in just a few different UOMs. If you have a more complex UOM model, you might need a more sophisticated solution. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******