compare values in column to average value

[Anonymous]

hello! I hope you are well while reading my message! / many thanks for taking the time to help me out!

I have a dimension (number of times a type of furniture is purchased).  And I would like to compare that to the mean (ie how far away from the mean is it).  How would I do that?

So I have:

     Purchase count     how far from mean?

total:       55                         5.5

               1                         ( - 4.5)

                2                         (-3.5)

               3                         (-2.5)

               4                         (-1.5)

               5                         (-.5)

               6                         (.5)

               7                         (1.5)

               8                         (2.5)

               9                         (3.5)

               10                        (4.5)

** So how would I get the numbers in parathesises to be calculated for me?

Thank you!

[sunny_talwar · Accepted solution]

May be like this:

[Purchase Count] - Avg(TOTAL [Purchase Count])

[Clever_Anjos]

If you´re using the same dataset