Overlap Calculation

Options
Previous Member
Previous Member
5 Up Votes First Comment 5 Likes First 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
    April Badge of the Month First Anniversary Level 200: Leveraging Board for Business Insights Level 100: Foundations of Building in Board
    Options

    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 First Answer First Anniversary 5 Up Votes
    Options

    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