Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Year | Employees | Cost | NewValue |
---|---|---|---|
2011 | 4 | 1300 | 14400 |
2012 | 5 | 2700 | 18000 |
2013 | 7 | 6800 | 25200 |
Hi
Something like this:
=Avg(Total Cost) * Only(Employees)
OR
=Avg(Total Cost) * Sum(Employees)
Hope that helps
Jonathan
=Avg(Total Cost) * Only(Employees) no work
=Avg(Total Cost) * Sum(Employees) give me no correct value
(Sum(TOTAL Cost)/Count(TOTAL Cost))*Employees
no work
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
=Avg(Total(cost))*Employee
Hi
=sum(avg(total(cost)))*employee
try this, it will work.
Anish
I supose in table you have Sum(Cost) and Count(Employees);
If true,try:
=sum(total Cost) / count(total distinct Year) * count(Employees)
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