Level 200 Module 205 Sales Actual GBP are multiplied by 1.88

jbienko1
jbienko1 Active Partner
Level 200: Building A Planning Solution in Board First Comment Name Dropper
in Academy

The issue is related to incorrect currency conversion in module 205.

I encountered the same problem as Eduardo in this thread:

https://community.board.com/discussion/16827/level-200-module-205-sales-actual-gbp-are-incorrect

Even the incorrect numbers I have are EXACTLY the same as Eduardo's.

What I noticed is that the incorrect numbers are multipled by 1.88 comparing to expected, correct results.

My guess is, that the problem occurs during the currency conversion stage.

There is a step in the procedure where the numbers in local currency (GBP) are multiplied by the exchange rate. It is done by multiplying the TEMP - ACT - DR - Sales LC matrix by currency conversion matrix (UTIL - FX Rates)

This step is expressed in the training materials as:

image.png

For some reason while multiplying those two matrices, instead of selecting only one currency (and multiplying by 1 in UK case), both numbers are taken, and as effect it is multiplied by 1 (GBP) + 0.88 (EUR) = 1.88.

I've reviewed training materials multiple times and compared with my config. But couldn't find the place where there is limitation applied to use only one currency while currency conversion calculation.

Any ideas?

Kind regards,

Jacek

Accepted Answer

  • Crystal Zhao
    Crystal Zhao Employee
    10 Comments September Badge of the Month Name Dropper August Badge of the Month
    Answer ✓

    Hi Jacek,

    I believe that what is missing is a way for the procedure to identify the currency type. Can you try adding a step that selects the currency based on another cube in the procedure? Here's what I did (Step 3.)

    image.png

Answers

  • jbienko1
    jbienko1 Active Partner
    Level 200: Building A Planning Solution in Board First Comment Name Dropper

    Thanks Crystal!

    This was exactly the step which lacked in the procedure. Now it works as expected.

    If you could also confirm my understanding of what is this action actually doing. It reduces (filters) all the following operations in the flow in the currency dimension to only the value(s) selected on the screen. So it applies the filter from the selector object to all further operations in the flow. Is that correct?

  • Crystal Zhao
    Crystal Zhao Employee
    10 Comments September Badge of the Month Name Dropper August Badge of the Month

    Hi Jacek,

    That is great to hear! And yes, you are correct in your understanding. Good luck with the rest of the course!

Categories