Hi All,
When I see my layout with fiscyear ,it shows the aggregated values for Quantity,Cost Per Unit,0Amount,which is distributed across period.
For example if one WBS and one uear(2008) -0Quantity(12),CPU(100) to four periods of one fiscyear.The distribution would be as shown below:-
Period 0Quantity CPU 0Amount
003.2008 3 100 300
004.2008 3 100 300
005.2008 3 100 300
0006.2008 3 100 300
Total 12 400 1200
So in my layout I'll be able to see :-
fiscyear 0Quantity CPU 0Amount.
2008 12 400 1200
So 12 * 400 <> 1200 which is logically incorrect.
Is there any way by which we can get the constant or average value of CPU from the cube???
Any help would be appreciated.
Rgds,
Indu
Hi Indu,
If you are using Query designer for generating report, you can have this property...In the properties of CPU>Calculate result as...>Average value...
This will give you the result as average of all the values.
Assign points if this helps u...
Regards,
KK.