Skip to Content
0
Sep 07, 2013 at 12:16 PM

Use previous column KF value in next column KF calculation

28 Views

Hi,


December 15, 2013 Dec-2013 Jan-2014 Demand 39,904 38,150 16,974 Supply 27,962 42,027 32,390 Projected Inventory 25,401 29,278 44,694

Example: Projected Inventory for Dec-2013 = Prev Period Inventory + Current Period Supply - Current period demand = 25,401 + 42,027 - 38,150 = 29,278

How can i use the previous values of inventory to calculate the next on the fly in query designer 3.5

Thanks

GS