Calculation Issue...

[Amritha]

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

[DavidSmith]

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

[Amritha]

thanks so much for letting me know.