Dear All,
I am presently working on the opening and closing logic for attrition calcuation and i am stuck.
i have implemented the logic in the attached file. the logic is working fine for month on month
but when i put any dimension in the chart and select multiple months then it gives me the wrong calculation
for attrition.
Attrition formula = (No of resignies in the Selected month)/((Closing for MaxMonth+Opening for Minimum Month)/2)
Please refer the attach qvw file for detail.
