Overlap Calculation

Previous Member
Previous Member
500 Up Votes 500 Likes 500 Comments Second Anniversary
in Platform

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

 

Answers

  • Nicolas CHIGROS
    Nicolas CHIGROS Active Partner
    Fourth Anniversary 250 Up Votes 25 Likes 10 Comments

    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
    Björn Reuber Employee, Community Captain
    500 Likes Fourth Anniversary 100 Comments 5 Answers

    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

Categories