Yearvalue and select

PrevContributor
PrevContributor
in Modeling

Dear all, is there somehow the possbility to use the yearvalue- and the select-function together? I want to transform year values to a monthly schedule and thereby just select a certain case from a list. Thanks you all in advance, Best regards

Tagged:

Answers

  • harish_bk
    harish_bk
    Hi Timo

    You can use the below script to acheive it than going with year value and select:

    1) Create a small module with current year as line item and list formatted time
    2) Give the line item value as current year from drop down
    3) In the monthly module write the formula and use the lookup function to the line item value in point 2

    Screen shot of fiscal year mapping module

    image

    Sample Formula:

    Value.Year modlue [LOOKUP:Fiscal year Mapping.Current Year]

Categories