Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 _CD_
		
			_CD_
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi all !
I've got something strange when trying to add reference lines on a line graph. As you see, I want 2 reference lines for 60% and 100%.
The displayed value for 100% is ok, but for 60% is ko (0.6). All decimal value I've tested are displayed live that.
Did I miss something in my graph ?
Thanks for any help
 paulcalvet
		
			paulcalvet
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hello,
Try to force the format with num function : num(0.6, '#,##0%')
Paul
Since you used expression with 1 always it returns 100%. Try to use 0.6 as expression and see?
 paulcalvet
		
			paulcalvet
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hello,
Try to force the format with num function : num(0.6, '#,##0%')
Paul
 _CD_
		
			_CD_
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Thanks for this Paul. It works with this simply patch.
But the issue is still there.
