Skip to Content
Former Member
Jun 27, 2011 at 06:44 PM

Apply a variable at Break level


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.