Running Total for inventory planning negative values.

I'm calculating planned inventory per month, using 2 running Totals, Demand and Underway stock Starting from Onhand stock the calculation is simple : Planned Inventory = Onhand - Demand + Underway ...