1 Reply Latest reply on Apr 10, 2015 10:09 AM by philmodjunk

    Average of grouped figures

    Stu412

      Title

      Average of grouped figures

      Post

      Hi,

      Let's say I have a simple table set up like this:

      CustomerID | Value

      1                | 10

      1                | 10

      1                | 10

      1                | 10

      2                | 10

      2                | 10

      2                | 10

      Total for Customer 1 = 40.

      Total for Customer 2 = 30.

      If I ask FM to do an average of value, it will return 10, based on 70/7 which is pretty correct.

      However, I want it to return 40 + 30 / 2 = 35, quite different from 10.

      How would I go about telling FM to average only the summed figures by customerID group?

      Thanks