Matrix calculation issues

Hello,
I have a matrix that has the following data
Week1 Week2 Week3 Week4 Week 5 ... Week 52
Total % a/z b/y c/x d/v e/
u aa/zz
Value 1 a b c d
e aa
Value 2 z y x v
u zz
The expression for Total %, sum(value1)/sum(value2)
The expression for Value1 is sum(value1)
The expression for Value2 is sum(value2)
All calcuations are correct.
Now, I added another level called Year and made Week expandable. So
Week can rolled up/collapsed into Year.
For some reason, when I collapse Week into year, the calculation for
Total % is incorrect. It shows me the Average of Total%
In other words, I see this:
+Year
Total % Avg( a/z, b/y,c/x....aa/zz)
Value 1 Sum(a,b,c,d...aa)
Value 2 Sum(z,y,x,v,u..zz)
Can anyone tell me why Total% is showing me an average as opposed to
Sum(a,b,c,d...aa)/Sum(z,y,x,v,u..zz)?
Thanks in Advance.
ClemOn Jan 29, 9:11 pm, clemts <clem...@.yahoo.com> wrote:
> Hello,
> I have a matrix that has the following data
> Week1 Week2 Week3 Week4 Week 5 ... Week 52
> Total % a/z b/y c/x d/v e/
> u aa/zz
> Value 1 a b c d
> e aa
> Value 2 z y x v
> u zz
> The expression for Total %, sum(value1)/sum(value2)
> The expression for Value1 is sum(value1)
> The expression for Value2 is sum(value2)
> All calcuations are correct.
> Now, I added another level called Year and made Week expandable. So
> Week can rolled up/collapsed into Year.
> For some reason, when I collapse Week into year, the calculation for
> Total % is incorrect. It shows me the Average of Total%
> In other words, I see this:
> +Year
> Total % Avg( a/z, b/y,c/x....aa/zz)
> Value 1 Sum(a,b,c,d...aa)
> Value 2 Sum(z,y,x,v,u..zz)
> Can anyone tell me why Total% is showing me an average as opposed to
> Sum(a,b,c,d...aa)/Sum(z,y,x,v,u..zz)?
> Thanks in Advance.
> Clem
What is the relationship between Week and Year in the report?
Enrique Martinez
Sr. Software Consultant