I have a series of values by month. I want to create a running total formula that sums the values until a set value (coming from another column) is reached. Once that set value is reached, only display that set value, take the remainder from the running total and continue with the running total, each time stopping at the set value and displaying that value.
Example: The Values are a forecast of items used each month. The set order point is 119. I want to show the months when the 119 items need to be ordered. I have tried a few things but am stumped. Is there a way to do this?
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Jan[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[TD]Apr[/TD]
[TD]May[/TD]
[TD]Jun[/TD]
[/TR]
[TR]
[TD]Values[/TD]
[TD]10[/TD]
[TD]74[/TD]
[TD]66[/TD]
[TD]65[/TD]
[TD]65[/TD]
[TD]47[/TD]
[/TR]
[TR]
[TD]Running total[/TD]
[TD]10[/TD]
[TD]84[/TD]
[TD]150[/TD]
[TD]215[/TD]
[TD]281[/TD]
[TD]328[/TD]
[/TR]
[TR]
[TD]What I want to see[/TD]
[TD][/TD]
[TD][/TD]
[TD]119[/TD]
[TD][/TD]
[TD]119[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Example: The Values are a forecast of items used each month. The set order point is 119. I want to show the months when the 119 items need to be ordered. I have tried a few things but am stumped. Is there a way to do this?
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Jan[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[TD]Apr[/TD]
[TD]May[/TD]
[TD]Jun[/TD]
[/TR]
[TR]
[TD]Values[/TD]
[TD]10[/TD]
[TD]74[/TD]
[TD]66[/TD]
[TD]65[/TD]
[TD]65[/TD]
[TD]47[/TD]
[/TR]
[TR]
[TD]Running total[/TD]
[TD]10[/TD]
[TD]84[/TD]
[TD]150[/TD]
[TD]215[/TD]
[TD]281[/TD]
[TD]328[/TD]
[/TR]
[TR]
[TD]What I want to see[/TD]
[TD][/TD]
[TD][/TD]
[TD]119[/TD]
[TD][/TD]
[TD]119[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]