How to allocate Number to list member based on Rank of list member

Highlighted
Contributor

How to allocate Number to list member based on Rank of list member

Hello Team,

 

I have list route which has parent city.Every City can have more that 100 route.every Route has capacity of goods can be transfer.i have ranked these route based on some factor.I want to allocate the demand quantity to these route based on lowest to highest rank considering capacity of route and.

    Demand100
      
pune capacityRankAllocation 
 route120120 
 route250250 
 route310310 
 route450420 

 

Thanks,

Ankit

                       

2 REPLIES 2
Highlighted
Master Anaplanner/Community Boss

Re: How to allocate Number to list member based on Rank of list member

@Ankitjain 

 

See if this helps. You may have to use RANKCUMULATE Function/Cumulate Function here

Misbah_0-1594624400128.png

 

Highlighted
Contributor

Re: How to allocate Number to list member based on Rank of list member

Thank You @Misbah , for pointing to correct function.

 

 I was able to achieve it with RANKCUMULATE function.

 

Thank you So much.