I have a pretty big saved search (in terms of columns and groupings) and was curious as to what the best way to show the quantity for items and for kits. So basically if it is an item, show the on hand. If it is a kit, show the number of kits on hand based on the item's on hand components

Use the member items join Do ROUNDDOWN({memberitem.location on hand}\{memeberitemquantity}) Then group by item name and use MIN of above formula

I can try it. it's grouped by many things, so that may throw it off

Is it a transactions search or an item search?

item search

I see, then my formula should be okay....however you are right if there is a lot of other columns and groupings going on then it could get complicated.

K thanks! Wish NS just gave us a column that did that calculation already