Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
I want to show only rows 'NameProduct' (column 1) with condition negative difference between columns 2 and 3 :

Column 1 = Dimension = NameProduct
Column 2 = Expression = Sum(QuantityProductInventory)
Column 3 = Expression = Min(SafetyStockLevel)
Column 4 = Expression = Sum(QuantityProductInventory) - Min(SafetyStockLevel)
 maxgro
		
			maxgro
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		you can try with a calculated dimension
if(aggr(Sum(QuantityProductInventory) - Min(SafetyStockLevel), NameProduct)<0, NameProduct)
and check the "Suppress When Value is Null" flag in Dimension tab
 maxgro
		
			maxgro
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		you can try with a calculated dimension
if(aggr(Sum(QuantityProductInventory) - Min(SafetyStockLevel), NameProduct)<0, NameProduct)
and check the "Suppress When Value is Null" flag in Dimension tab
 
					
				
		
Perfect !!! Thx a lot...
Stanley
