Hi All -
Was hoping I could get some ideas/help on this problem that I'm trying to solve. I am trying to automate the output of the "allocation" line item shown below. I have a set amount that I need to distribute into various list items based on the priority shown. The max amount allocated is shown in the first column. I'm looking for a solution that can scale; assume that the list of items is large. Not looking for logic that says something like "if priority = 1 then X else if priority = 2 then Y". Hope this makes sense.