Top Level Summing

Hello,

I have two modules A, B dimensioned by Region and Currency. The currency type has a top level of All currency due to that in module B the numbers are summing up x4 times based on module A(PFA screenshot). How do I get it to look at one currency at a time? I tried adding a look up and trying item(currency)= for each currency type. How

Answers

  • Hi,

    As I understood, In region module u need a data as per currency selection. Please find below steps:

    1. Create a module dimensioned by Currency and region.
    2. The apply formula like Calculation = Data/Currency Rate (Currency conversion rate is coming from Module 1 which is dimensioned by Currency only ).

    Hope that helps.

    Thanks

    Ashutosh