Avarenge

[fabiano]

I have dimension with calctype=2 and 2 value column: 15 and 30 = 45 / 2 = 22,5. but total column is 20.

This correct?

[AlexZencovich]

I have dimension with calctype=2 and 2 value column: 15 and 30 = 45 / 2 = 22,5. but total column is 20.

This correct?

Average in total calculated not as sum rows above/ number of rows but as sum all values which used in calculation in rows above/number of values used in calculation.
Example

row1 2+3+4+5 = 14 / 4 = 3.5
row2 6+7+8+9 = 30 /4 = 7.5

total value
wrong way = (3.5 + 7.5) / 2 = 5.5
right way = (2+3+4+5+6+7+8+9) = 44 /8 = 5.5

but if you have 0 values or distinct enabled you may get various results.