Dynamically apply the currency conversion on the currently active level in an entity hierarchy drill down/ cyclic group
Dear Community users,
There is a finance dashboard problem involving multiple currencies.
[Region(ASIA), Regional Currency-USD] -> [Company(Australia/NZ), Company Currency-AUD] -> [Entity(Australia),Entity Currency-AUD] OR [Entity(NZ), Entity Currency-NZD].
The transactional data is mapped at the lowest level i.e. entity and hence the local currency is applied at the this level. The data has to be aggregated with respective currency exchange rates at higher levels.
