Sum Column with Parameter

Previous Member
edited April 2020 in Platform

Hi All,

 

I Have data like this

image

 

How Board calculate when safety stock is sum Demand Next Week until 3 Weeks?

Answers

  • Previous Member
    edited March 2020

    Hi,

    In Board there are different way to to manage Time offset and shift, also using parameter, but this solutions generally need to  run a procedure.

    If you simply need  to calculate a fixed coverage You can do it on flight on the report.

    image

    Just  set the covered as the value in the cube Demand with:

    1. YMT  = sum of the week (in my example month)
    2. Offset= 3 take the value of the next 3 month
    3. Cycle= 3  make the sum (YMT) with step=3  (after 3 step the sum restart)

    The result should be that you need:

     

    image

  • HI Davide Corbetta,

     

    Thats work well. Thanks