Skip to Content
avatar image
Former Member

Where [dimension D1] = [dimension D2]

Hi all,

I need to obtain the previous month's stock volume.
Fiscal Period and Volume are data that I have. Previous period is a variable. I want to derive the 4th column.

I tried to create a variable : Prev mth vol = [Volume] where ([Fiscal period]=[Previous period]). But it showed blanks.

Can someone advice how should the formula be written? Thanks in advance.

table.png (83.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 18 at 04:54 PM

    Hi,

    Try Relativevalue([FiscalPeriod];-1)

    Thanks,

    Jothi

    Add comment
    10|10000 characters needed characters exceeded