Hi, I need some help with a workbook I'm making. The workbook is to see all the components on the current BOM Revision. I have two issues I'm currently trying to overcome. 1. In the Preferred Vendor column list only the preferred vendor and do not make additional lines for items that aren't the preferred. 2. Show the base price of the component item Current columns: • Item Name/Number • Formula: ON HAND {billofmaterials.currentrevision.component.item^item.totalquantityonhand} • Component: billofmaterials.currentrevision.component.item • Component Description: billofmaterials.currentrevision.component.description • Preferred Vendor formula: CASE WHEN {billofmaterials.currentrevision.component.item^item.itemvendor.preferredvendor} = 'T' THEN {billofmaterials.currentrevision.component.item^item.itemvendor.vendor#display} END *How do I tell it not to return results when the vendor isnt preferred?) • Component Quantity: billofmaterials.currentrevision.component.quantity • Average Cost of component Formula: {billofmaterials.currentrevision.component.item^item.averagecost}*{billofmaterials.currentrevision.component.item^item.stockunit} • Purchase Price component Formula: {billofmaterials.currentrevision.component.item^item.cost}/{billofmaterials.currentrevision.component.item^item.stockunit} • Base Price of Component: Need Solution. I tried {billofmaterials.currentrevision.component.item^item.price} no luck. Attached is a screenshot showing current progress. red lines showing which lines I don't want to show, we are currently showing oto preferred vendor formula. Some more background: I'm making this workbook to replace a saved search which no longer works for our assemblies since we enabled Supply & Demand (which required Advanced BOM).