Splitting single line item into multiple line item

AdamSayyad
AdamSayyad
in Modeling

Hello Team,

As project requirement I need to split the total annual amount into month wise and under different heads. I have created one input model where end user will input the amount.

image.png
image.png

expected output is as below

image.png

Amount will get spit based on certain rule defined. I am clear about the calculation of amount and output model. Just wanted to know the best practice to implement this into Anaplan and how to create Mutiple line item based on this single input.

Have kept this list as numbered # list since user will input or delete or change data.

The aim to create output/result model Maintenace free.

Could you please advise, what would the best way to approach this scenario.

Regards,

Adam S.

Best Answer

  • rob_marshall
    rob_marshall
    Answer ✓

    @AdamSayyad

    See if this works for you…

    Your input:

    image.png

    I have added a couple of line items after Anaplan Calcs

    image.png

    Create a "staging" module to get the data into a timescale

    Lists: Input Rows (which is the same as above) and Time

    image.png

    which looks like this:

    image.png

    Now, for the Result:

    image.png

    image.png

    Hope this helps,

    Rob

Answers

  • AdamSayyad
    AdamSayyad

    @rob_marshall Thank you for your help..I built the same way after posting this question..but I put formula in staging module..It's seems your approach is right to avoid multiple calculation at Staging module better to do calculation into Input model and then bring the amount into Staging model. Will do the changes as advised by you ..😊

  • rob_marshall
    rob_marshall

    @AdamSayyad

    Good deal…Having those calc's in the input module will help it perform better.

Categories