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 |
Hello,
This should work perfect.
=Avg(Total Cost)*Employees
Please find attached qvw
Regards,
Manideep
Hi,
Check with this
=$(=Sum(Cost)/ Count(Distinct Year))* Count(Distinct Employees)
Hope it helps
Your solution works. But the field Employees and Cost are 2 expressions.
Employees = count(person)
Cost = sum(costs) / sum(count(person))
If I try
avg(all sum(costs) / sum(count(person))) * sum(count(person))
no work!
Your solution works. But the field Employees and Cost are 2 expressions.
Employees = count(person)
Cost = sum(costs) / sum(count(person))
If I try
avg(all sum(costs) / sum(count(person))) * sum(count(person))
no work!
Did You tried with this?
=$(=Sum(costs) / Count(person)) * count(person)
Celambarasan
Hi,
Tis could help you.
Here is the solution you need,
LOAD * INLINE [
Year, Persons, Cost
2011, 2, 650
2012, 2, 1350
2013, 5, 3400
2011, 2, 650
2012, 3, 1350
2013, 2, 3400
];
Take Year as a Dimension in straight table and add following 4 expressions:
Employees: =Sum(Persons)
Actual Cost:=Sum(Cost)
AverageCost:=Aggr(Sum(Total Cost),Year)/3
Final:=AverageCost*Employees.
After this right click on properties-->Presentation tab--> Select AverageCost Column and select Hide Column option.
You can also set No Totals option to every column.
Here is the Output Table
Year | Employees | Actual Cost | Final |
---|---|---|---|
2011 | 4 | 1300 | 14400 |
2012 | 5 | 2700 | 18000 |
2013 | 7 | 6800 | 25200 |
Please find the attached qvw.
Regards
Manideep
(Sum(TOTAL Cost)/Count(TOTAL Cost))*Employees