funkmonsteruk
IS-IT--Management
Something quite bizarre has happened while using Business Objects and i was wondering if anyone could explain this phenomonam...
I have a report which has a field called cash balance. when all of the data in the report was grouped together i highlighted this column and selected sum - this gave me a correct figure for all the cash balances, however when i added a break into the report and broke it into sub sections (based on cost centres) and then selected the sum feature the figure that BO gave me was incorrect, the figure was about £2,000 under what it should have been, i manually calculated the cash balances and just didn't seem to be able to able to find out why the figure was this amount out.
When i re-grouped the data the figure was once again correct, am i doing something wrong? Or is their something far more sinister going on?
I have a report which has a field called cash balance. when all of the data in the report was grouped together i highlighted this column and selected sum - this gave me a correct figure for all the cash balances, however when i added a break into the report and broke it into sub sections (based on cost centres) and then selected the sum feature the figure that BO gave me was incorrect, the figure was about £2,000 under what it should have been, i manually calculated the cash balances and just didn't seem to be able to able to find out why the figure was this amount out.
When i re-grouped the data the figure was once again correct, am i doing something wrong? Or is their something far more sinister going on?