I have report consisting of Physician,Department,Metric,RateOfMetric, Rating Scale. One Physician in some cases belongs to more than one department hence i created a break a Metric level so that user can see the performance of the Physician for a Metric irrespective of the department.
I wanna know how to apply a variable at the break leve which will be the Rating Scale at the break level.
Physician(ABC)--- Section applied
Dept Metric Rate Rating Scale
X A 80 2
Y A 95 1
Overall A 92 ? ---Break applied on Metric
Rate i calculated using the Num & Deno columns and then applied a sum for those columns and accordingly calculated the Rate at the break level. If use the Rating Scale object at the break level it gives #MULTIVALUE error.
Pls suggest some way around.