If you are unable to create a new account, please email support@bspsoftware.com

 

Roll up Average Issue , Type of Average Calculation in Anaysis Studio

Started by raja1718, 09 Oct 2013 03:39:32 PM

Previous topic - Next topic

raja1718

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



raviahuja21

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.

raja1718

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