AnsweredAssumed Answered

Average of grouped figures

Question asked by Stu412 on Apr 10, 2015
Latest reply on Apr 10, 2015 by philmodjunk

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

 

Outcomes