Summing on Period (Quarter)

Options
CommunityMember113484
CommunityMember113484 Member, ALL USERS, Community Member Posts: 5 Occasional Contributor
in Planning & 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:

Categories