Summing on Period (Quarter)
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.
Module 2 is dimensioned by time (quarters) and the loan amounts are converted at the quarterly FX rates.
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.