How to get the values form different time periods

kishoreanimi
kishoreanimi
in Modeling

i want to get the values from non time period to time period module. how shouid i get it

Capture 111.PNG
Capture2222.PNG

Best Answer

Answers

  • Venki9902
    Venki9902
    edited May 2023

    Hi @kishoreanimi ,

    If you want to get the value from non-time period to period, let's say in your case. You can use yearvalue() function to get the data.

    Regards,
    Venkatesh

  • BrunoRodriguez
    BrunoRodriguez

    Hello @kishoreanimi,

    I believe there is an easier way to do this, so please let me know if you can follow the below:

    • Create a dimensionless module that will drive you start end end entry years.
    image.png
    • Find a logic for your hard coded numbers ranging from 5 to 1
    image.png
    • Enter your numbers and apply the logic that you have created previously:
    image.png

    I believe this solution requires less hardcoding that the one you were proposing and it is already dimensioned by the native Anaplan time.

    Please let me know your thoughts.

    Cheers!

    Kind regards,

    Bruno Rodriguez

  • kishoreanimi
    kishoreanimi

    Trying the exact way .but the year difference coming different values. Any h

    Screenshot 2023-05-08 205234.png

    int on this

  • BrunoRodriguez
    BrunoRodriguez

    Hello @kishoreanimi ,

    Have you populated correctly "SYS Module for HHP and Buy rate"?

    Cheers!

    Kind regards,

    Bruno Rodriguez

  • kishoreanimi
    kishoreanimi
    Screenshot 2023-05-08 214746.png

    Yes I did

  • BrunoRodriguez
    BrunoRodriguez

    Hello @kishoreanimi ,

    Is you model dimensioned by weeks?

    Kind regards,

    Bruno Rodriguez

  • kishoreanimi
    kishoreanimi

    Thank you i got i

Categories