Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
 suepenick
		
			suepenick
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		When I use this expression it works
StdCost * (Sum(if (SaleType='Pontoons', QtyShipped)))
but when I want to Total it, it will not work
SUM ( StdCost * (Sum(if (SaleType='Pontoons', QtyShipped))))
any Ideas?
 
					
				
		
 
					
				
		
test the next just add sum the first expression:
sum(StdCost) * (Sum(if (SaleType='Pontoons', QtyShipped)))
regards!!!!
 
					
				
		
Or this way
Sum (if (SaleType='Pontoons', QtyShipped*StdCost))
 
					
				
		
 Sokkorn
		
			Sokkorn
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi Penick,
Did you try below script yet?
Sum({$<SaleType = {'Pontoons'}>} StdCost*QtyShipped)
Regards,
Sokkorn
 
					
				
		
 suepenick
		
			suepenick
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		This one made the total go into the billions.
 
					
				
		
 suepenick
		
			suepenick
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Thanks!  You can't even know how many different ways I tried to make this work.  and then I look at your solution and want to slap myself on the forehead!  Thanks so much
  Thanks so much
