Hello Folks,
I am having an Issues with the Average calculations with % Values.
When i am drag and drop with the rows and columns and Measures with %. It calculate the Summary by default Average %.
Example
Country Dimension:
USA CANADA MEXICO
Time Dimension : 2013 October 100 % 75 % 100 %
2013 November NA NA NA
2013 December NA NA NA
Summary (Avg) 33.33 % 25 % 33.33 %
Required Summary (Avg) 100.00 % 75.00 % 100.00 %
Its Calculating the average by including the future month's November and December also
I want to calculate the average only for the value available for the month. its working fine when we use the summary function in the analysis studio but when i drag and drop default its calculating like the above table.
How can get the average by default excluding the empty values.
Thanks in Advance
Raja
I think you should use YTD which would basically contain months till october, I think that will give you the correct results because what Analysis studio is doing here is it is simply diving it by the no of elements count.
Folks,
I almost resolved this issue using the option in the transformer( Skip the blank and null values in the transformer measure properties)
roll up working fine now . if anyone in the same scenario,try to develop the calculations on the Transfrmer instead of Framework Manager.
Thanks every one ! ! !
Raja