I have a BAQ I have worked on for over one month. So much, I am missing the obvious next step.
The requirement was to create a BOM Explosion with true ASM information for ALL parts Active and Mfg in past 720 days. Dont ask why, it is crazy. This BAQ draws from JobAsmbl and Job Material to give all levels of the break down the data.
I have it delivering this information but now need to narrow it down to a single explosion instance of each ASM 0 Part. I cannot do this by MAX(Completion Date) or Max(JOB) as the plant floor often BATCHES production runs so the complete on the same date.
How can I create a calculated field that simply returns one instance of each ASM 0 Part? Sorry, I am absolutely beyond FRIED on this one.
Attached is a copy for review and ANY help is appreciated. I have to get this one off my plate after SO much time.