Sum Column with Parameter

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

  • 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

Welcome!

It looks like you're new here. Sign in or register to get started.
Sign In

Welcome!

It looks like you're new here. Sign in or register to get started.
Sign In