BusinessObjects Board

How to divide in Reporter

Ok the problem is as follows:

I need to divide two SUM results of two columns in BO Reporter.
These results are the outcome of two formulas.

So the formula should be something like this:

Result Column 1 / Result Column 2

But:

Result Column 1 = SUM of all the rows
Result Column 2 = SUM of all the rows

I cannot find a way in BO Reporter to do this, any of you guys do?
Thnx in advance


Inholland (BOB member since 2004-12-07)

In theory you should be able to use:
= (sum()) / (sum())

But if the sums are both giving the grand total for all data…

Are you summing dimension objects?
Is the table within a section? — if so are you using multiple queries?

Using an un / incorrectly linked dimension obj as the section can cause
the sums to go haywire…

Do you have an example report?


Reporter Bloke :uk: (BOB member since 2004-05-20)

Thnx for the fast reply.

The objects are dimension objects and are in the same context.

But the problem is solved in the mean time.
Somehow the query worked this time.

BO Reporter is a little weird sometimes.

BTW, what are the main benefits of BO Reporter in comparison to MS Excel?


Inholland (BOB member since 2004-12-07)

Thats a massive question. Here is a bit of a discussion which touches on this sort of comparison.


Nick Daniels :uk: (BOB member since 2002-08-15)

Thanx Nick


Inholland (BOB member since 2004-12-07)