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.
BR,
Rishit
