RunTotRowsλ() creates a running total for values in each row of an array
RunTotRowsλ( Values )
Values
(Required) A one or two dimensional array/range of values to create running totals for.
In this example we are determining projected inventory levels for all products by subtracting demand from production.
In the upper left corner is our customer Orders table. In it we have confirmed orders and planned orders. Each order is for one or more products, each with its own quantity and due date. This table is then place in the Product Demand forecast array placed under the timeline using ScheduleValuesλ().
In the upper right corner is our Production Schedule table. It identifies how many of each product will be made each day starting on its effective date and continuing until the production quantity for that product is set to 0. This table is then processed and placed in the Product Production array under the timeline using ScheduleRatesλ().
To project inventory we subtract demand from production and create cumulative totals for each product in the Product Inventory array using RunTotRowsλ(). In this example, demand for product #3 will surpass production and create an inventory shortfall in March.