4 Replies Latest reply: Apr 17, 2015 4:46 AM by AVIRAL NAG

# Logic Required...................!!

Dear All

Below is the Snapshot of my Requirement:

Also, see the Attachments.

Regards

Av7eN

• ###### Re: Logic Required...................!!

Anybody has the Answer for this........???

• ###### Re: Logic Required...................!!

These expressions should do the trick in your second Chart:

Sum({<CommonYear={\$(=max(CommonYear))},CommonMonth={"=\$(=Max(CommonMonth))"}>}[Attrition Left])

Sum({<CommonYear={\$(=max(CommonYear))},CommonMonth={"<=\$(=Max(CommonMonth))"}>}[Attrition Left])

Sum({<CommonYear={\$(=max(CommonYear))},CommonMonth={"=\$(=Max(CommonMonth))"}>} ClosingMOB)

Sum({1<CommonYear={\$(=Max(CommonYear))},CommonMonth={"<=\$(=Max(CommonMonth))"}>} ClosingMOB ) / Max(CommonMonth)

((([Cumulative Attrition]/[Avg Closing MOB])*100)/Max(CommonMonth))*12

• ###### Re: Logic Required...................!!

Thank You Sir.

It's Logical.

Regards

Av7eN

• ###### Re: Logic Required...................!!