Forum Discussion

IanWA's avatar
IanWA
Regular Visitor
9 years ago
Solved

Calculate Average Growth using Test sequence showing Infinity

I need to display the average growth for students from one test to the next where each test has scores for a number of areas.  I can't use dates as I'm after growth between from test 1 to up to to 6 ...
Need Help
  • IanWA's avatar
    IanWA
    9 years ago

    Solved it.

     

    Should have used:

     

    Growth1 = (AVERAGEX(Sheet1,  [Ass2]) - AVERAGEX(Sheet1,[Ass1])) / AVERAGEX(Sheet1, [Ass1])

     

    although I don't really understand why.

IanWA's avatar
IanWA
Regular Visitor
9 years ago

Sorry, left out the screen shot of the issue.  I'm getting infinity or -1.

 

 

 

 

IanWA's avatar
IanWA
Regular Visitor
9 years ago

Solved it.

 

Should have used:

 

Growth1 = (AVERAGEX(Sheet1,  [Ass2]) - AVERAGEX(Sheet1,[Ass1])) / AVERAGEX(Sheet1, [Ass1])

 

although I don't really understand why.