
1. Re: Difference of Two Columns as a Calculated Field
pooja.gandhi Mar 24, 2016 11:25 AM (in response to Gene Denny) 
2. Re: Difference of Two Columns as a Calculated Field
Gene Denny Mar 24, 2016 11:38 AM (in response to pooja.gandhi)And how did I know that Pooja would be the first to jump on this one!
Thanks, friend! That answers my question. I'll work on the formatting now!

3. Re: Difference of Two Columns as a Calculated Field
Nicola Prime Dec 18, 2016 11:08 PM (in response to Gene Denny)Hi Gene,
Can I ask if you managed to format the above so that the variance sat on the same row as the 2015 and 2016 data?
Thanks
Nicola

4. Re: Difference of Two Columns as a Calculated Field
Gene Denny Dec 19, 2016 6:34 AM (in response to Nicola Prime)Hi, Nicola!
I ended up with this.
% Prof Current Year and % Prof Previous Year are both table calculations. From there, Pooja helped me construct a calculated field IA Assessment Trend which computed the difference. That calculated field was defined as:
(SUM([# Prof CY]) / SUM([# Students Current Year]))  (SUM([# Prof PY]) / SUM([# Students Previous Year]))
Basically, it allowed me to compute my percents on each side of the minus sign and then compute.
Does that help?

5. Re: Difference of Two Columns as a Calculated Field
Nicola Prime Dec 19, 2016 10:29 PM (in response to Gene Denny)So in the 'previous correct' answer from Pooja, did you put calculation 2 onto the rows field?
I have a similar formula for mine, but have the same issue as Pooja's original version as I can't find a way to get the variance in line with the rest of the data.
Thanks
Nicola

6. Re: Difference of Two Columns as a Calculated Field
Gene Denny Dec 20, 2016 8:23 AM (in response to Nicola Prime)I went a little different route from the original question to make it meet new local requirements, but Pooja's calculated field is what allowed me to get to that point. Here's a little bigger screenshot of the layout I used. Hopefully this will give you what you need, because I'M HEADED TO THE BAHAMAS!