Date input query

Hi,

I have a module with various bank loans and maturities e.g. 2020-2028 - this is dimensioned by quarters.

I want to create a module that sums up the total bank loans by maturity. I've used a formula YEAR to extract the maturity year, but I can't seem to be able to sum on this year?

Can anyone assist?
Thanks!

Accepted answers

All comments

Anilkumarch

Hi @CommunityMember113484 create a line item and capture the quater value if it is maturing then create another line item with time dimension as year and write a formula to pull data from line item where you are storing loan amount if maturing.

You need to enable summary for line item of laon amount if maturing.

Below screenshot for ref.

CommunityMember113484

Hi- thanks for your response. Can you explain how I am able to capture the quarter value of when it is maturing?
In my input module, I have a maturity date and loan value, dimensioned by quarters.
I have now created a new module per your screenshot, but how do I get total loan value by quarter? In my module, my total loan amount is showing in Q3 2020 because that is the value input for Q3 2020, rather than maturing Q3 2020?

Anilkumarch

Hi @CommunityMember113484 Write a condition in "Loan Amount if maturing" line item saying if mature year is equal to time scale year then take the mature value else keep zero. Then you will get sum values of loan amount which are maturing that year at year dimension.

CommunityMember113484

Thanks - what would the formula for time scale year look like?

Anilkumarch

@CommunityMember113484 if your target line item dimension is Year than automatically you get the sum if summary is enabled for source line item.

Let us connect and discuss if you still not able to get it.

Quick Links

Can you help?

Unanswered questions

Action to copy data from one version to another version only for a specific module
Ideally, I would like to setup an action that can copy data from one version to another only for a specific module. For every new version I create, I import new data into certain modules and then I manually copy data over for a specific module. I am wondering if I can just setup an action to select an origin version,…
Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…