PREVIOUS() for line items in a module not involving time dimension

shrey
shrey
in Modeling

I am working on a module in which have two related line items (L1 & L2)& a dimension "Period."  For Period A is L2=0, Period B L2 = Period A L1 and so on. I am trying to figure out a calculation for the Non-time series module. Example of module given below:

      Period A/Period B/Period C/Period D/Period E

L1        13/15/16/18/19

L2         0/13/15/16/18

 

what is the best way to do it? 

Tagged:

Best Answer

  • nathan_rudman
    nathan_rudman
    Answer ✓

    Hi,

    One way is to build into your period list a "previous" property and fill it with the previous element.

    If it's a changing list, you can have that property be filled automatically with a formula searching for text/numbers or rank()

     

    Then you can do L1[LOOKUP:Period.previous]

Comments

  • shrey
    shrey

    Hi Nathan

     

    Thank you for the reply

     

    I tried implementing the above in a module but I received the following error

    "Data type mismatch: format other than LIST or DATE being referenced as a relation"

     

    I am fairly new to Anaplan and have not been able to figure out this isse.

     

  • nathan_rudman
    nathan_rudman

    What is the format of the previous property you created in the list ?

  • shrey
    shrey

    Period.Previous is Integers. Period is essential 0 to x. Would that be a problem?

  • nathan_rudman
    nathan_rudman

    Yes, Period.previous should be list fromated as Period and then you can input the value yourself

  • shrey
    shrey

    That worked.

     

    Thank you so much!!

Categories