Avarenge

Discussion forum for PivotCubeX component. Common usage questions. Bug and problem reports

Moderator: Alex Zencovich

Avarenge

Postby fabiano » Fri Jul 07, 2006 8:41 pm

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

This correct?
fabiano
User
 
Posts: 16
Joined: Fri Jul 07, 2006 8:04 pm

Re: Avarenge

Postby AlexZencovich » Fri Jul 07, 2006 9:16 pm

fabiano wrote: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.
Best regards,

Alex Zencovich
-------------------------------------------------------------------------------------------------------------------------------------------
www.pivotcube.com - OLAP solution for Delphi, C++ Builder and ActiveX environment
AlexZencovich
Site Admin
 
Posts: 580
Joined: Sun Jun 18, 2006 10:09 am


Return to PivotCube ActiveX

Who is online

Users browsing this forum: No registered users and 1 guest

cron