Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 Mahmoud
		
			Mahmoud
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hello,
I want to show only the rows where "Ventes" = 0
Expression CA net: Sum({<Mouvement_ID={'AC'},Date={">=$(vDateP1D)<=$(vDateP1F)"}, Typologie ={"NEW"}>} Total_Net_HT)
Expression Ventes: Sum({<Mouvement_ID={"VC"}>} Total_Net_HT)
Thank you
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		May be this
Expression CA net
If(Sum({<Mouvement_ID={"VC"}>} Total_Net_HT) = 0,
Sum({<Mouvement_ID={'AC'},Date={">=$(vDateP1D)<=$(vDateP1F)"}, Typologie ={"NEW"}>} Total_Net_HT)
)Expression Ventes
If(Sum({<Mouvement_ID={"VC"}>} Total_Net_HT) = 0,
Sum({<Mouvement_ID={"VC"}>} Total_Net_HT)
)
					
				
			
			
				
			
			
			
				
			
			
			
			
			
		 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		May be this
Expression CA net
If(Sum({<Mouvement_ID={"VC"}>} Total_Net_HT) = 0,
Sum({<Mouvement_ID={'AC'},Date={">=$(vDateP1D)<=$(vDateP1F)"}, Typologie ={"NEW"}>} Total_Net_HT)
)Expression Ventes
If(Sum({<Mouvement_ID={"VC"}>} Total_Net_HT) = 0,
Sum({<Mouvement_ID={"VC"}>} Total_Net_HT)
)
					
				
			
			
				
			
			
			
			
			
			
			
		 Mahmoud
		
			Mahmoud
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		it works, Thank youuu 🙂
