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


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? 

Best Answer

  • nathan_rudman


    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]


  • 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.


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

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

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

  • That worked.


    Thank you so much!!