Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
Hi Guys/Girls
I want to create a set analysis like such with a calculation at the end: so I set the producer group, but for that set i want to do a calculation
sum({$<[Producer Group] = {"Pool"}>}FOB?EXW/[Standard Carton Equivalent])
But that does not work...
Any help will be appreciated
Regards
Andre
 
					
				
		
 sorrakis01
		
			sorrakis01
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
sum({$<[Producer Group] = {'Pool'}>}[FOB?EXW])
/
sum({$<[Producer Group] = {'Pool'}>}[Standard Carton Equivalent])
Regards
 marcus_malinow
		
			marcus_malinow
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Try this:
sum({$<[Producer Group]={"Pool"}>} [FOB?EXW]/[Standard Carton Equivalent])
 
					
				
		
 sorrakis01
		
			sorrakis01
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
sum({$<[Producer Group] = {'Pool'}>}[FOB?EXW])
/
sum({$<[Producer Group] = {'Pool'}>}[Standard Carton Equivalent])
Regards
 
					
				
		
 sorrakis01
		
			sorrakis01
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
In your expression you use double cuote
sum({$<[Producer Group] = {'Pool'}>}FOB?EXW/[Standard Carton Equivalent])
