Is it possible to roll forward balance within the same List?

Highlighted
Contributor

Is it possible to roll forward balance within the same List?

Hi,

 

I have Deal List and Funds List with their Top Levels and Beg. Available Fund, Fund Utilization for the deal, and Remaining Fund as the Line Items.

 

In module, Deal list and Funds List appearing in the Rows (Each deal has the same Funds list appearing again) and Line items in columns.The scenario is, one by one each Fund will utilize their available amount for all the deals so whatever left after spending on Deal 1 the Remaining Fund will become Available Fund for Deal 2 and so on.

 

Is there any way I can roll forward  the remaining amount deal by deal?

 

Thanks!  

 

 

 

 

 

 

 

 

 

14 REPLIES 14
Highlighted
Master Anaplanner/Community Boss

Re: Is it possible to roll forward balance within the same List?

@sharmagh 

Never tried that but sounds like a good use case for Closing Balance summary.

Try setting up an account that has additions and reductions. Assuming you're scenario is time based you can simply use the ending balance at the beginning of your next deal. You'll also have a way to replenish the account if you have additions.

Very similar to an Open to Buy (for retail)

ClosingBalance.png


Jared Dolich
Highlighted
Contributor

Re: Is it possible to roll forward balance within the same List?

Thank! However, I am not using any time scale
Highlighted
Valued Contributor

Re: Is it possible to roll forward balance within the same List?

@sharmagh 
could you clarify something for me, please?
Are Deal and Fund 2 hierarchies with Fund being the Parent of Deal? 
So I have Fund 1 with an available $ of $1M
 For Example:

Fund 1
----- Deal 1.1
-----Deal 1.2

Fund 2

-----Deal 2.1

 

I have 2 Deals within the Fund Fund 1 -Deal 1.1 and Deal 1.2 and you want to distribute the $1M between these 2 Deals?

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
Highlighted
Contributor

Re: Is it possible to roll forward balance within the same List?

.@einas.ibrahim
No Funds and Deals are two diferent list with Active fund and Pipeline deals as top levels
Highlighted
Contributor

Re: Is it possible to roll forward balance within the same List?

@einas.ibrahim 

No Funds and Deals are two diferent lists with Active fund and Pipeline deals as their respective top levels.

 

Highlighted
Valued Contributor

Re: Is it possible to roll forward balance within the same List?

@sharmagh 

I believe I understand your issue, but it is more of a design issue rather than a technical issue.
One technical fact though that will help us think through this is the following:

A line item can not be a user input and contain a formula at the same time. it is an either-or situation. **

 

There are a few ways to distribute a finite amount (fund $ for example) over a list of deals, but as I said it depends on the design.

 

Based on what you said about the Fund and Deal lists, a deal can be funded from any fund and a fund can fund any deal. Is that your intention?
Please see the attached image for clarification.

 
 
 

image.png

 

Or you have a fund 1 that should fund Deal1 and Deal2 while fund 2 to fund Deal3 and Deal4?



** There are 2 workarounds to this situation:
1. You can use a process to update an input Line Item

2. If you use version formulas.

Neither of these is applicable to this situation but I added them for completion.

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
Highlighted
Contributor

Re: Is it possible to roll forward balance within the same List?

Can i use offset function without time period or time scale in module?
Highlighted
Valued Contributor

Re: Is it possible to roll forward balance within the same List?

@sharmagh 
No.
OFFSET is a Time and Date function.

 

Have you seen this post by another contributor?
https://community.anaplan.com/t5/Anaplan-Platform/PREVIOUSITEM-PREVIOUS-on-a-list/td-p/24575

I think you will still have a circular reference. 

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
Highlighted
Contributor

Re: Is it possible to roll forward balance within the same List?

Didn't work either.