Sum of all average

[rahulsud007]

Dear All,

I need to find sum of all the average which I have calculated and Multiplied by previous coloumn

In the below application the 0-1 value field calculates the average amount and multiplied by Quantity and I would need sum as shown in the image.

Please Help ..:)

[mohamed_ahid]

hi ,

if i understood , you need to use the function Column (int ColumnNo) .

column(1)+column(2).... and so on .

is it that ?

let me know .

regards

[rahulsud007]

NO dear,

Above sum the expression which I used is

(avg(VE.Cost per unit) * coloumn1) using pick Match and for sum I need total of all those items which is above sum.

tried using sum( avg (VE.cost per unit) * Coloumn1) but it didnt work properly. THis is for expression 0-1 value.