Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
 ch_riadh
		
			ch_riadh
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		How can i Count ID if the NAME start with 'A'.
I try this expression
Count( if Name = 'A*' , ID )
but it s not working
 tresesco
		
			tresesco
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Try:
Count({<Name={'A*'}>} ID)
 MK_QSL
		
			MK_QSL
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		COUNT(IF(Name Like 'A*', ID))
 anbu1984
		
			anbu1984
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Count( if( Name Like 'A*' , ID ))
 
					
				
		
try like this
aggr(if(name='A*')i,d)
 anbu1984
		
			anbu1984
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Count( if( Wildmatch(Name,'A*') , ID ))
Or
Count( if( Left(Name,1) = 'A' , ID ))
 
					
				
		
 ch_riadh
		
			ch_riadh
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Thanks
