I admit that I haven't read everything in your formula, but it appears that the IF condition:
=if (Program_Dash = 'Kit Build',
that is verified outside of any aggregation, might be the cause of the problem. If you expected this condition to be verified for each data row, then it should be positioned within the aggregation functions, and preferably be replaced with Set Analysis.
The way it appears now, the formula will only work when there is one and only one available value for the field Program_Dash. As soon as multiple values are available, the condition will always return FALSE.