Avg(Aggr Don't seem to consistently work.

[Coolavin]

This is the formula I am using:

Avg(Aggr(Sqr(Stdev(ItemScore)), ExamForm, ItemName))

You can see in the screen shot below that only the first two rows are being populated with this formula. However,  the data points of ExamForm, ItemName and Sqr(Stdev(ItemScore) all have data that can be used. 

I can' t figure out why the formula isn't using the data on the 3rd row and below.  It seems like the problem is with Avg or Aggr. 

Any ideas what I am doing wrong?

[marcus_sommer · Accepted solution]

You may try one or both possibilities from here:

Avg(Total Aggr(NoDistinct Sqr(Stdev(ItemScore)), ExamForm, ItemName))

- Marcus

[Coolavin]

Thanks Marcus, it looks like this solution fixed it!