I have a problem statement where I am trying to do some allocation basis rank traversal
there is fixed quantity Q= 900 which i have to distribute amongst vendors .
e.g if i allocate 100 to V1 basis some logic, then I am calculating remaining quantity for allocation to other vendors V2 where I calculating remaining quantity = Q- cumulate of allocated till now. Here I am facing issue of circular reference. I need to stop traversing whenever remaining for allocation is zero or cumulate of allocated till now equals the fixed quantity Q which we had to distribute.
What is it that you are trying to do in your Allocated formula? If I trust my mathematical skills you are having Truck capacity in numerator as well as in denominator which will cancel each other and you ultimately have the same "Total" or "Remaining" amount
I think you are trying to allocate the Total numbers based on the truck capacity and then burn it down until it reaches the maximum limit or is there any other calculations that goes into Allocated Line item?