You can notice that for some opportunities the value for Expected Value is showing a different value from the opportunity level. This is happening for all reports based on the data source Opportunity Header and Item.
Reproducing the Issue
- Open any report based on the data source Opportunity Header and Item, e.g: Opportunity Pipeline.
- Add the key figure Expected Value to the view.
You will see that for some opportunities the key figure is presenting a different value in relation to the opportunity.
The reason for that is that the default SAP standard key figure Expected Value takes into consideration several factors from the opportunity in order to calculate the Expected Value.
In order to solve this situation, you can add another key figure from the Add Fields button.
Then, on the Settings > Key Figures screen, select the key figure Expected Value (Transactional Currency) and make it available by replacing the Expected Value key figure.
This key figure Expected Value (Transactional Currency) takes into consideration the exact value and currency from the Opportunity level without taking into consideration any of the opportunity aspects.
KBA , expected value , expected revenue , key figure , data source , analytics , reporting , opportunity header and item , codoppu , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To