Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
Hi everybody,
I have to do this.
SUM of "Number"
Concept = 'Concept1'
And 'Installation' has to be emtpy , i mean i don't have to have values in this field.
the two first are this
| SUM({<Concept = {'Concept1'} >}Number) | 
But how i do the last thing?
Am i clear?
Thank you, greetings!
 
					
				
		
Is this?
| SUM({$<Instalattion={'*'}-{''}, Concept = {'Concept1'} >}Number | 
If this is correct. Now i wanna have the same but when Instalattion IS NOT empty
how i do that?
Thanks
 
					
				
		
 marcus_sommer
		
			marcus_sommer
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Try something like this:
SUM({<Concept = {'Concept1'}, Instalattion -= {'*'} >} Number)
- Marcus
 
					
				
		
 reshmakala
		
			reshmakala
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Does your original post mean that installation should be a null value? or you do not want to include it in the expression?
 
					
				
		
The field 'Installation' has to be emtpy , it dont have to have vallues, null.
 
					
				
		
It doesn't work!
 
					
				
		
Without the - i dont have errors
 
					
				
		
 reshmakala
		
			reshmakala
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hope this helps
 
					
				
		
I didn't understand
what i have to put after the =-?
 
					
				
		
OK the answer is THIS
Sum({$<SET THAT IS NOT NULL -= {""}>}THIS IS THE OPERATION)
