Hi Mark,

Not sure if i understood what you mean, let me give another go at explaining, i need to sum all the values and divide the result by the number of rows, how would it be the best way to get there?

Below some of the expressions used on the column:

Line by line expression (to obtain USD current amount for each Area and SubArea in your example customer):

=Sum(Fields!Total_AR.Value)*

IIf

(

Fields!SubArea.Value = "Unassigned",

Lookup

(

"% Current" & Fields!Area.Value & Parameters!Period.Label,

Fields!Metric.Value & Fields!Area.Value & Fields!Fiscal_Month.Value,

Fields!Target.Value,

"Target"

),

Lookup

(

"% Current" & Fields!SubArea.Value & Parameters!Period.Label,

Fields!Metric.Value & Fields!Area.Value & Fields!Fiscal_Month.Value,

Fields!Target.Value,

"Target"

)

)