I'm trying to pull a saved search for my Assemblies. I am getting what I want for the most part but really just want to see
Assembly item with quantity built for that assembly
2 components fields (Packaging Labor and Mixing Labor)
with what I have now it's pulling all items in assembly when all I really want is the assembly item with quantity produced and the 2 component fields above. Do I need to change some summary types to get where I want to go?
c
christianRILECPQ
09/09/2025, 2:37 AM
Yup, that’s a summary issue. Group by Assembly Item, then use SUM on Qty Built. For components, add CASE formulas to only pull Packaging Labor + Mixing Labor.