Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
substringcount(concat(%dim3,'|'),fullname) and get selectedcount(%dim3)<>0
here what it do ? i know work functionality of concat but here quite different what it do here?
 ashfaq_haseeb
		
			ashfaq_haseeb
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
Part 1
substringcount(concat(%dim3,'|'),fullname)
To count with or without any selection
Part 2
getselectedcount(%dim3)<>0
To count for Selection, This condition here means there must be some selected values
Hope it helps
Regards
ASHFAQ
 
					
				
		
 alexandros17
		
			alexandros17
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Yhe first expression count how many "fullname" there are in the string composed by %dim3 while the second expresion count how many values you have selected in field %dim3
 
					
				
		
it means how many full names are there in the %Dim3 or in the string selections of %Dim3
 its_anandrjs
		
			its_anandrjs
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		First one counts the full names while second one that is getselectedcount(%dim3)<>0 is a condition which checks how many value selected in the %dim3. And it is worked only where there is some value selected in the field %dim3 at least one value.
Regards
Anand
 
					
				
		
 alexandros17
		
			alexandros17
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		The first expression (Used in a object, not in the script) returns all the values for selected field depending on the expresion, so the result can be different from the second expression
 
					
				
		
it counts the no of full names in %dim3 ? OR selections of %dim3 pls tell me
 
					
				
		
If you will select anything for %dim3, then it work work over that select set of data, otherwise if nothing is selected it will traverse over all values of %dim3.
Hope this was helpful.
Thanks,
Singh
 ashfaq_haseeb
		
			ashfaq_haseeb
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
Part 1
substringcount(concat(%dim3,'|'),fullname)
To count with or without any selection
Part 2
getselectedcount(%dim3)<>0
To count for Selection, This condition here means there must be some selected values
Hope it helps
Regards
ASHFAQ
