Current Year (time scale: not applicable)

LucaRicci
LucaRicci
in Modeling

Hello,

How can I get the information contained in "current year - list" (year dimensioned) and put it into "current year"(non-year dimensioned)?

image.png
image.png

Thanks in advance,

Luca

Tagged:

Answers

  • rob_marshall
    rob_marshall

    @LucaRicci

    Turn on All Periods for the model timescale or time range. The formula for Current Year would be 'Current Year - List'[Select: Time.All Periods]

  • Dikshant
    Dikshant

    Do you need a line item to display current year? Create a line item with time period format as Year and write the formula: PERIOD(CURRENTPERIODSTART())

    Note: You need to maintain the current month in the model calendar.

  • LucaRicci
    LucaRicci

    @Dikshant unfortunately I need the "current year" line item to stay as it is. Isn't there a workaround?

  • Dikshant
    Dikshant

    Write this formula in your current year line item only. And set current period in model calendar. You will get the result as FY24

  • LucaRicci
    LucaRicci

    @Dikshant ok, I am trying but still not working. What do you mean by "set current period in model calendar"?

    image.png
    image.png

  • Dikshant
    Dikshant

    Can you share the screenshot of model calendar? Go to the time icon. Did you setup current period?

  • LucaRicci
    LucaRicci

    @Dikshant unfortunately we are not using it.

    image.png

    We are using this instead

    image.png

    Can I still pull it off?

  • Dikshant
    Dikshant

    Change your formula from PERIOD(CURRENTPERIODSTART()) to SYS98 Current Actual Period.Current Year

  • LucaRicci
    LucaRicci

    @Dikshant big thanks, sorry

Categories