Overlap Calculation

Previous Member

Hi All,

Please help me how to get my "End Stock from week 27" and will be place to "Opening Stock week 28"

Formula to get Opening Stock = If (Demand last last week is 0 then get Opening Stock last week else get End Stock)

Formula to get End Stock = Opening Stock + Incoming - Demand

Find more posts tagged with

Accepted answers

All comments

Nicolas CHIGROS

Did you had a look at Time functions in the help? You should be able to do what you want using a Dataflow, some references and time functions

Otherwise maybe look into nexel.

Regards

Björn Reuber

Hi,

you can simply solve it using a rule with . before the code (Defining a Rule ). Then it's refering toi the Block (not column) before the value.

The column offset. This operator allows you to define a formula that refers to a previous column on the Layout. Normally, Rule formulas are calculations between cells located in the same column. The block offset allows you to refer to any cell on a previous column. A column offset is indicated by a dot (character ”.”) prior to the member code. For example, the formula =[.C01] refers to the cell on row C01 and one column to the left. This function avoids recursive resolution of formulas which refer to other calculated cells.

then you only need your block at lest wice in the layout (as block a without rule and with a time offset) and as block b with the rule

regards

Björn