Decile story: Why deciles were incorrect - 05/24

Yesterday while working on a deliverable, deciles (segmenting in 10 segments) were coming incorrect for HCPs. 

To decile HCPs (Health Care Professionals), sort them in descending order of their Patient count. Then apply the below formula to decile: 

=(11-ROUNDUP((SUM(C$2:C2)/SUM($C:$C))*10,0))

We were wondering why deciles were not coming correct and the reason was that we had not sorted the HCPs in descending order. 

In the end when we came to know the reason we were relieved and I said, "Deciles करेक्ट आए ना आए, आएंगे तो मोदीजी ही!" (Even if Deciles do not come, PM Modi will come for sure)

Some lighter moments are needed during tense work situations.

Follow me on LinkedIn