I would like to figure out how to correctly show the variance of a item that is in a kit.
Qty 1 I receive from one source and Qty 2 comes from another source. I'm unsure what type of formula would be needed to show the variance like below.
How about something like the attached?
Depending on your logic and real data structure, this may need to be adapted to fit your situation. I assumed the the way to identify a sub-part was the Part starting with a space.
