Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We need to calculate weighted ratings for multiple measures. The formula looks like below.
Rating = Sum( Aggr(MeasureRating * Max(Weight), Measure)) / Sum(Aggr(max(Weight), Measure))
For each measure, each organization, there is a MeasureRating. When select any of Organization, it will show Rating for all measures this organization has. We also want to show the overall rating for the whole network (include all organizations). When select any one organization this overall rating should not change.
I already calculated each MeasureRating for the whole network, however, some organization has less number of measures. If I select this kind of organization, the "Measure" I used inside Aggr() is less than total number of measures the whole network has. Is that possible to use Total function inside Aggr to get all measures?
Not entirely sure I understand what you are looking to do... Would you be able to share a sample or sample data with the desired output?
aggr( sum(MeasureRating * Weight), Measure)) /
max( total Aggr(sum(Weight), Measure))
I attached the application in another link:
It seems not correct.