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

Ankitjain

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.

				Demand	100
pune		capacity	Rank	Allocation
	route1	20	1	20
	route2	50	2	50
	route3	10	3	10
	route4	50	4	20

 

Thanks,

Ankit

                       

Misbah

@Ankitjain 

 

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

 

Ankitjain

Thank You @Misbah , for pointing to correct function.

 

 I was able to achieve it with RANKCUMULATE function.

 

Thank you So much.