Level 200 Module 205 Sales Actual GBP are multiplied by 1.88

jbienko1 · 2024-05-16T11:49:40+00:00

There was an error rendering this rich post.

jbienko1

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:

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

Find more posts tagged with

Accepted answers

Crystal Zhao

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.)

All comments

Crystal Zhao

Hi Jacek,

jbienko1

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

Hi Jacek,

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