how do I get the average of lookup value from ssrs?

Question

=Lookup(dsc.Value,Dsc.value,Fields!Fmotion.Value,"Stage") I want to get average of that lookup value. How can i write an expression that shows average of that lookup value?

Answer 1

Lookup(x,x,x,x) only returns a single value; the first match in the dataset that it finds and the average of a single value is obviously that value. If you want the average of all values that match your Lookup condition, use the LookupSet function to return multiple values. Then you can use the code behind ability to embed VB code and return an average for the LookupSet