Skip to Content
avatar image
Former Member

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

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)
Add comment
10|10000 characters needed 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?

  • Get RSS Feed

0 Answers