I'm trying to pull a saved search for my Assemblie...
# general
a
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
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.