Top Level Summing

tampara.dora
tampara.dora
in Academy Discussions

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

Screenshot 2023-06-14 at 5.41.15 PM.png

Answers

  • Ashutosh
    Ashutosh

    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

Categories