Yearvalue and select

Previous Contributor

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

Super Contributor

RE: Yearvalue and select

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]