Hi there, 
I have a case I have yet not found a solution for.  The case is that I have  prognosis, and historical data, which comes from two different streams in the workflow and then joined.  However, if a certain company xxx does not have any historical data, then i dont want any data flowing further in the left stream of the join. 
That is, there is a condition before the join which is that [Total_sum] !=0. If company xxx has [Total_sum] = 0, it means that it will go to te left in the join, and I want to stop all data flowing through the left as it goes further to a union.
Is there any good way of achieving this ?
Kind regards
Ole 
I will try this solution and see if it works for my purpose. Thanks 🙂
/
 
					
				
				
			
		
