Yearvalue and select


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


  • 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


    Sample Formula:

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