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
Did you try exactly column(1) / column(2) ?
Can you share a screenshot of what you have trying?
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.
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!
Retrieving data ...