Hi,
I am having an issue with trying to get a figure in BW. I'm would like to report standard price from the material master and show them in the query. Standard price should NOT be a summation as the report should show the details of the standard price based on the material. I've set the Infoobject aggregation as:
Aggregation: SUM
Excep. Aggr: Average(all values)
Char: CALMONTH.
Everything works fine when I place this in the report. However when I start to put in other calculated/restricted key figures the values shown is incorrect (i.e. two records containing the same materials are summed instead). This only happens when I put in calculated/restricted key figures. Pls. help.