Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
hi
i have a situation in which i am using an expression and in the expression i have to sum a measure based on two dimensions.
like sul({$<prodid={'a'},size shouldnt be equal to xl...........what is the sign to be used for not equal to???
 
					
				
		
Try this Sum({$<prodid={'*'}-{'a'}>} )
 
					
				
		
 jonathandienst
		
			jonathandienst
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi
SImpler than that
Sum({<prodid-={'a'}>} size)
The expression will work. Don't worry about the wiggly line syntax warning, but that's a well known bug in the script editor syntax check.
Regards
Jonathan
