Comparison with y-1, results from last year

Options
Kris2000
Kris2000
in Modeling

Hello,

I'm trying to build a module, where we compare the results with the results of one year earlier. Whey we change the year or date, the columns highlighted in yellow, should automatically show the data from one year earlier.

How can I do this? Using a formula?

image.png

Tagged:

Answers

  • umangsinghal
    umangsinghal
    Options

    Use offset formula. Below is the syntax:

    OFFSET(Value to offset, Offset amount, Substitute value)

    Regards,

  • pyrypeura
    pyrypeura
    Options

    Hi,

    Could you provide us some detail why you have rejected @Umang Singhal 's answer?

  • Dikshant
    Dikshant
    Options

    @Kris B,

    You can also use a lookup function. Go to SYS: Time Settings by Year Module and line item with formula ITEM(Time) - 1 and use that as lookup in your main module.

Categories