I have two Planning Layouts. One is to plan quantities and prices per year and the other one does the same thing per month.
When I plan per month and then switch to the "year layout", BPS doesn't show the average price but summs up all twelve price records.
Layout 1: JAN FEB MAR ... QUAN PRICE QUAN PRICE QUAN PRICE 15 2.99 18 2.49 12 3.00 Layout 2: 2006 QUAN PRICE 45 8.48 But what I want is: 2006 QUAN PRICE 45 2.83
I have already tried to change the underlying InfoObject (exception aggregation). But that seemed to have no effect at all.
I can't think of any way to get this working. I would think though, that this is a pretty straight forward and common scenario... doesn't it happen often, that people are using BPS to plan with prices (on different levels)? How do you get it to calculate averages instead of sums?
All help is highly appreciated!