none
weighted average calculation RRS feed

  • Question

  • Hi everyone!

    I have a filter that has a hierarchy (Department ->Practice Area -> Subgroup-> Fee Earner) and is connected to a scorecard.

    For example, if one specific department is selected in the filter, the scorecard shows the specific department and the children of this department(Practice Area). For showing the department value, I am taking the "Sum of Children" as calculation in the KPI, the operation in this case is working properly. The problem is that I have some KPI's that should be the weighted average of their children. I have tryed to use the "Default" as calculation in the KPI with no success. Do you have any idea how can I get this?

    Thanks in advance.

    Best regards,

    Eriel

    Wednesday, May 4, 2011 12:49 PM

Answers

  • To get weighted average you would need to set your measure as null where they come up 0. That could be handled at Analysis Services calculated measure; just add a condition if measure is zero set it to null. By default these null values would be excluded from average calculations.
    http://dailyitsolutions.blogspot.com/
    Saturday, May 7, 2011 5:09 PM