average of rows in a column

[#1]

Hi all.

I have a table as this:

1 dimension: Year

3 expression: Employees, Cost, NewValue

Year	Employees	Cost	NewValue
2011	4	1300	14400
2012	5	2700	18000
2013	7	6800	25200

I want calculate the colum NewValue. It is given: avarege of all the value in the column cost multiplied by each value of the column Employees.

14400 = (1300+2700+6800)/3 * 4

18000 = (1300+2700+6800)/3 * 5

25200 = (1300+2700+6800)/3 * 7

any ideas?
Thanks!

[jonathandienst]

Hi

Something like this:

     =Avg(Total Cost) * Only(Employees)

OR

     =Avg(Total Cost) * Sum(Employees)

Hope that helps

Jonathan

[#3]

=Avg(Total Cost) * Only(Employees) no work

=Avg(Total Cost) * Sum(Employees) give me no correct value

[er_mohit]

(Sum(TOTAL Cost)/Count(TOTAL Cost))*Employees

[#5]

no work

[kaushiknsolanki]

Hi,

     Have a look at the application attached here with.

     If this is not how your data structure is then kindly upload the qvw file.

Regards,

Kaushik Solanki

[nayanpatel]

=Avg(Total(cost))*Employee

[#8]

Hi

=sum(avg(total(cost)))*employee

try this, it will work.

Anish

[#9]

I supose in table you have Sum(Cost) and Count(Employees);

If true,try:

=sum(total Cost) / count(total distinct Year) * count(Employees)

[#10]

If in expression you have Cost and Employees like is seen in table(no aggr functions like sum,count) try:

=sum(total Cost)/count(total distinct Year) * Employees