Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
How can I give percentage format to a specific row for the below table ?
 
					
				
		
 stigchel
		
			stigchel
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		In the expression that calculates the percentage you can use Num with the formatting option like this
=Num(Count(Id)/Count(TOTAL Id),'0.0%')
Or go the number tab of the properties and select display as percentage for that expression
 
					
				
		
Thank you Piet for the prompt reply,
but actually the above expression wont work, I have already tried that with percentage format.
If we are giving percentage in Number tab in properties, it will get applied to the whole column, Here i want it in a single row.
 
					
				
		
 stigchel
		
			stigchel
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Assuming then that Percentage,Test1... is a dimension you can use something like
If(YourDim='Percentage',Num(YourExpression,'0.0%'),YourExpression)
