I have a summary saved search looking at Item Receipts, and have the value at the line level. My user wants to see this value at the lot level. How do I set up the formula so that I can allocate the amount from the line to each of the multiple lots entered. when I group by lot, the value is 0. How do I properly set the formula for
(max({amount})/max{quantity}))*{inventorydetail.itemcount}

or

max({amount})/{inventorydetail.itemcount}

I have

and want to see lot qty amount or 24,806.40*(2340/2560) = 22,674.60 for the first lot, and 24,806.40*(220/2560) = 2,131.80

Here is my search results