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

                       

Best Answer

  • Misbah
    Answer ✓

    @Ankitjain 

     

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

    Misbah_0-1594624400128.png

     

Answers

  • Thank You @Misbah , for pointing to correct function.

     

     I was able to achieve it with RANKCUMULATE function.

     

    Thank you So much.