Use "Previous" with non-timescale dimension

GeorgeDuckett
GeorgeDuckett
in Modeling

Hi all,

I understand Previous() can't be used with a non-time dimension. I have a custom dimension with a natural concept of a previous item. (it's actually a 13 period calendar that is not based on weeks, therefore I think precluding the use of a native time dimension).

GeorgeDuckett_0-1649170599225.png

I understand why it's comlaining; OpeningBalance references ClosingBalance and ClosingBalance references OpeningBalance. When using PREVIOUS works as Anaplan is smart enough to know that the references aren't actually circular, however when doing the lookup it can't enforce that, and therefore gives an error.

Is there any way around this issue?

 

Tagged:

Best Answer

  • mburdak
    mburdak
    Answer ✓

    Hi @GeorgeDuckett ,

     

    You just need to change the formula for the Closing Balance. In order to calculate Closing Balance, you don't actually need to calculate the Opening Balance first.

    mburdak_0-1649223795035.png

    Blueprint View:

    mburdak_1-1649223828310.png

     

    If you need to incorporate an opening balance for the first period, that can also be accomodated using IF statements in the Opening & Closing Balance lineitems.

     

    Hope this helps.

     

    Regards,

    Mandeep Burdak.

Answers

  • Misbah
    Misbah

    @GeorgeDuckett 

    The only workaround I can think of is that you create this module with Anaplan Native Time dimension. And Step 2 would be to create a mapping between custom time and native time and bring back the values to your existing module

     

    Thanks,

    Misbah

    Miz Logix

  • rob_marshall
    rob_marshall

    @GeorgeDuckett 

     

    @Misbah is correct, the only way around this is to do the calcs using Native Time and then "reporting" it with your Custom Time list by way of a mapping module.  The reason you are getting a circular reference is explained in this document (all detailed members in your custom time are in the same block of data).

     

    Rob

  • GeorgeDuckett
    GeorgeDuckett

    @mburdak Ahh, clever, thanks; I wasn't aware of CUMULATE. That's done the trick!

Categories