Opening and Closing Calculation

[lalitinmbd]

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.

[vikasmahajan]

Can u give solution for my thread Cummulative Graph

Vikas