variable values picking wrong

[Anonymous]

HI All,

I created variables. if I click on Audit & Assurance  and Staff variable values picking  wrong. I'm getting more than 100% in graph.

More than 100 % is wrong. Head count table having data for every month. Attrition table not having data for all months.(No employee exit in some months) Head count variables picking correct and Attrition variables picking wrong while selecting filters.

I need Attrition 14 months data and  Head count 14 months data .

Mar'2014 to Apr'2015 ....Last 14 Months

Mar'2015 to Apr'2016......Current  14 Months

(In HR terms Attrition = Employee Exit)

Rolling Attrition = 14 Months Attrition Emp count/Avg Head count.

Avg Head count= 14 Months Head count/14

  Variables:  

vAttritionMonth=AddMonths(Max([Attrition.Attrition Reporting Month - Orginal]),-13)

vAttritionMonth1=AddMonths(Max([Attrition.Attrition Reporting Month - Orginal]),-11)

vAttritionMonth2=AddMonths(Max([Attrition.Attrition Reporting Month - Orginal]),-25)

vHeadCountMonth=AddMonths(Max(Head_Count.CDate_H),-13)

vHeadCountMonth1=AddMonths(Max(Head_Count.CDate_H),-11)

vHeadCountMonth2=AddMonths(Max(Head_Count.CDate_H),-25)

Expressions:

Round(Count({$<[Attrition.Attrition Reporting Month - Orginal]={'>=$(=vAttritionMonth2)<$(=vAttritionMonth1)'}>}Attrition.Emp.Id)
/Round(count({$<Head_Count.CDate_H={'>=$(=vHeadCountMonth2)<$(=vHeadCountMonth1)'}>}[Head_Count.Emp. Id])/14)*100)/100

=Round(count({$<[Attrition.Attrition Reporting Month - Orginal]={'>=$(=vAttritionMonth)'}>}Attrition.Emp.Id)/
(count({$<Head_Count.CDate_H={'>=$(=vHeadCountMonth)'}>}[Head_Count.Emp. Id])/14)*100)/100

Dimension

FunctionOthers

Filters:

FunctionOthers

Grade

Thanks,

Krishna.

[Gysbert_Wassenaar]

You divide the headcount by 14 to get a monthly average headcount. But you don't divide the attrition count by any number of months. That's why you get funny numbers.