Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 Karthick30
		
			Karthick30
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
I am having a column which has blank values. I don't want to remove that. I need to count that. So I used formulas like
if(isnull(column),'NA',column) and if(len(column)>0,column, 'NA')..
but still my table column is not showing NA as value.. showing blank ( - ) value
Anyway to fix this
 
					
				
		
 Or
		
			Or
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Assuming you are working within a table (not a pivot) and these are measures, those approaches should work as you expect (you could also use Coalesce(column,'NA')).
Could you elaborate on what exactly it is you're doing, in what object type and what context?
 stevejoyce
		
			stevejoyce
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		why not just this? i'll add a trim just incase its blank spaces... if(len(trim(column))>0,column, 'NA')
