Profile for prior periods

willridge
willridge
in Modeling

The profile function is great when you want to calculate data from a start month for future periods, it would be great if it would also work to profile data going back in time from the start month

Tagged:

Answers

  • andrewtye
    andrewtye

    A question would be why? Might be worth posting it in Idea Exchange.

    And I think you could do this with combination of lag/post plus profile so pushing it back as far as needed and then running the profile off of it...

  • ManjunathKN
    ManjunathKN

    Hi @willridge 

    It was fun to Build this, I have given my try. This is a workaround by logics!
    Module 1

    ManjunathKN123_0-1643998960430.png

    ManjunathKN123_1-1643998995186.png

    Module 2 (Allocation using Allocation list)

    ManjunathKN123_2-1643999039261.png

    ManjunathKN123_3-1643999067475.png


    Hope this helps!

    Thanks,
    Manjunath

     

     

  • willridge
    willridge

    @andrewtye Apologies, I meant to post this in the idea exchange. Happy to delete it from here if it helps.

Categories