Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
Hi,
I am working in a chart. and the first two values in the chart are numbers resulting from each sums.
and I want to do column(1) / column(2).
but whenever i use + - / it says I am using bad field name.
How do I deal with this???? this is very werid
Thanks!!
 squeakie_pig
		
			squeakie_pig
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		If for some reason that is still not working (and it should), you can also use the expression names
[name you called column 1] / [name you called column 2]
eg. in my example it would be: [Actual Stuff] / [Not Actual Stuff]
even though column(1)/column(2) works just as well for me here.

 Clever_Anjos
		
			Clever_Anjos
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Did you try exactly column(1) / column(2) ?
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Can you share a screenshot of what you have trying?
 squeakie_pig
		
			squeakie_pig
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		If for some reason that is still not working (and it should), you can also use the expression names
[name you called column 1] / [name you called column 2]
eg. in my example it would be: [Actual Stuff] / [Not Actual Stuff]
even though column(1)/column(2) works just as well for me here.

 
					
				
		
Hi Guys,
Thank you I just figured it out.
It says bad field when I type in the operational symbols but when I finish up the rest of the script it says expression ok. so I guess I just had to finish the entire script!
Thank you all!
