Skip to Content
0

The exchange rate is aggregated and the Net Value is showing wrong figures in the story

Mar 30, 2017 at 08:48 AM

42

avatar image
Former Member

We need an urgent help from you.

In my model ZM_ORDER_INTAKE, we have written a ‘simple’ formula Net value = Net Value (in Document Currency) * Exchange rate.

But in the story, the exchange rate is aggregated and the Net Value is showing wrong figures. Refer to the below screenshots.

For e.g., consider the sales orders 0100000002 and 0100000024.

Material 32 is repeated 12 times in the sales order 0100000002.

In sales order 0100000024, material 17 is repeated thrice and materials 16 and 147 repeated twice.

This aggregated value is considered for the Net value calculation.

Note that exchange rate is 1 in all the cases.

If Net Value (Doc Curr) is 100 for sales order 0100000002, the total Net Value is now shown as 1200.

In the story, we want to show the Net value at company level or sales office level only; not at individual sales orders or materials..

Please advise how to achieve this.

xpirv.jpeg (68.7 kB)
5vbqq.jpeg (21.6 kB)
xkxip.jpeg (16.5 kB)
ivvwi.jpeg (16.0 kB)
10 |10000 characters needed characters left characters exceeded

Sorry for the delay in responding

Knowledge Accelerator is a training tool; so I don't think this is the right tag

Which SAP tool are you using? SAP Analytics Cloud?

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers