Splitting single line item into multiple line item

AdamSayyad

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.

expected output is as below

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.

rob_marshall

@AdamSayyad

See if this works for you…

Your input:

I have added a couple of line items after Anaplan Calcs

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

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

which looks like this:

Now, for the Result:

Hope this helps,

Rob