Hi All,
Is there a way to set up a Weight Average on the below example?
I have dimesions as 2 Depts ( HR, Admin, IT and so on...), 2 Designation (CEO, VP, PM, SSE, SE and so on), 4 Months ( Jan, Feb....Dec and Full year), and 1 Salary Calc ( Head Count, Salary, Avg. Salary)
India HR
JAN FEB MAR APR MAY ............... FULL YEAR
SE - HC--100
SAL--$10
SSE - HC --50
SAL --$50
PM - HC --10
SAL --$100
Weight Avg Sal = 100*$10+50*$50+10*$100/(100+50+10)
I am working in Planning Analyst and our end users would like to see the Weight Average of Salary as 'Final Result = 28.15'
Thank you in advance for your help.
Regards,
Amritha
Simples!
Against the Salary dlist item, use the weighted average field and choose headcount. This will ensure that the "total" salary calc doesn't just add up, but weights as per your calculation
Dave
thanks so much for letting me know.