UPDATE: I initially sent wrong info!
I have the following situation:
PERIOD WEEK Actual Forecasts
7 27 2000 2500 2000
7 28 3000 3000
7 29 4500 4500
What I want to see when I rollup to Period is the following:
PERIOD Actual Forecasts
7 2000 10000 9500
What I get is the following:
PERIOD Actual Forecasts
7 2000 10000
2000
any suggestions??
Listserv Archives (BOB member since 2002-06-25)
Dianne,
I’m not sure what the last column is (ie, ).
It appears that the middle column (ie, Forcasts) is summing properly while Actual and the last column are not. Did you verify that the measures that are not summing are defined the same as the Forecasts measure? I would think that you would have that measure defined as the SUM(table.forecasts). Verify that all your measures use the aggregate SUM() function.
HTH,
Donald May
maydp@pweh.com
Listserv Archives (BOB member since 2002-06-25)