Hello, You can use the rankcumulate function : https://help.anaplan.com/4727e9c5-4687-45ec-a4a0-420d30476d42-RANKCUMULATE Create one "priority" line item per child and one "need" line item per child, and use it for your rankcumulate : Child 1 Child 2 Child 3 Priority 1 2 3 Need 60 50 40 Rankcumulate 60 110 150 allocation (50) 50 0 0 allocation (120) 60 50 10 Thanks to that, you will be able to have the allocation with a formula like MIN(Need, MAX(TotalStaff - Rankcumulate + Need,0)) I hope this is what you wanted to do
... View more