How can i get the crossover by function

143kishornaidu
143kishornaidu
edited January 2023 in Modeling
Capture.PNG

Hi ,


As per the screen shot, in the left grid whenever i select the y the the left grid should show the

same year start month and end month and if i select the y-1 ans week 44 the value then the right side grid should show the 2022 and 44 the week month +1 year


how can i achevie this in a simple way

Tagged:

Answers

  • Misbah
    Misbah

    @143kishornaidu

    Whatever I could understand - it is a typical filter driven grids, meaning you can have "Y" key and "44" key in filters and drive the grids using these filters.

    Thanks,

    Misbah

    Miz Logix

  • billdowling
    billdowling

    Hi,

    For this type of question I would have a SYSTEM module that maps Weeks to the Planning Window.

    In your example you could then use an IF statement to lookup the values for either Y or Y-1. Below are some screenshots of a simple example:

    SYSTEM module for weeks:

    image.png


    INPUT module to set the planning week:

    image.png


    CALCULATION module to work out the planning window:

    image.png


    Hope this helps.

    Bill

Categories