Summing on Period (Quarter)

CommunityMember113484
CommunityMember113484
in Modeling

Hi,

I need some help in summing on the maturity period (quarters).

 

Module 1: no time dimension, standing data showing loan amounts in various currencies, and maturities.

 

CommunityMember113484_0-1648218373626.png

 

Module 2 is dimensioned by time (quarters) and the loan amounts are converted at the quarterly FX rates.

CommunityMember113484_1-1648218623297.png

 

Module 3 is dimensioned by time (quarters) and I want to create a module that shows when the loans mature.  How do I go about doing this?
I've tried summing on the converted loan amounts in Module 2 which does not work. Summing on the standing data allocates the loans to the correct maturity period, but the loans are of various currencies and need to be converted into EUR.

Thanks,

Tagged:

Comments

  • billdowling
    billdowling

    Hello,

    If I have understood this correctly, I think you should be able to achieve this in Module 2.

    I set up the following modules:

    Module 1 with the standing data not dimensioned by time

    image.png

    Module 2 with the currency values

    image.png

    I added the line item to test the item quarter against the maturity period

    image.png

    Which allows you to pivot the report by time to see the values that mature by quarter.

    image.png


    Regards

    Bill

Categories