1 Reply Latest reply: Jan 17, 2013 9:20 AM by Stefan Wühl RSS

    Aggregating averages (urgent)

    Georgina Spary

      Well I managed to mark my question as Assumed Answered by mistake and now I can't undo it. so here's a repeat to draw it to your attention.

       

      Hello folks

       

      I am really stuck on this and was due to release the report today! so really hoping you can help.

       

      The attached shows an average score for students, against a heirarchy of dimensions: student number, programme, department, faculty. Each student has only one score. Each student is studying 2 programmes: BI and one other.

       

      I am trying to avoid double-counting the students at Faculty level while showing an accurate figure at programme and student level. see attached for 2 failed versions.

       

      Thanks in advance

       

      George