3 Replies Latest reply on Jul 8, 2016 9:23 AM by Luciano Vasconcelos

# Need assistance with percent difference calculated field

Hello everyone,

I need assistance in writing a calculation that calculates the percent difference between each individual student compared to the entire school average.

So in the sample table below, if Jim B's average grade in 2013 was 46.5% and the school average in 2013 was 23.6%, what is the percent difference?

Normally when I am working with percent difference, it's always in relation to time ((new-old)/old), however in this instance both are based on the same time period, so I just want to check with all of you first.

Would that calculation still be used in this case?

So again, if I wanted to compare Jim B's grade in 2013 to the overall school average in 2013, would it be ((46.5%-23.6%)/23.6%)?

Jim B.46.5%56.6%
Sara S.78.2%78.2%
David S.54.6%62.7%
Sam L.12.3%98.6%
Damon R.52.3%18.6%

School Average2013 AVG Score
2014 AVG Score
Entire School Average23.6%54.6%
• ###### 1. Re: Need assistance with percent difference calculated field

Yep, pretty sure you've got it.  What kind of visual are you going for with it?

• ###### 2. Re: Need assistance with percent difference calculated field

Darren

With a sample file, it would be easier

Here is how I would do it:

(

(IF [Name]='Jim B.' THEN AVG([Measure 2013 Score]) END)

-

AVG([Measure 2013 Score]

)

/

AVG([Measure 2013 Score])

Alexis

• ###### 3. Re: Need assistance with percent difference calculated field

Darren, if you use Fixed clause with Student as dimension in your calculation you'll keep the total value ignoring student filters.