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.
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?
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.