Percentage calcs - as variable or in report?

building reports webintelligence
1

I need to calculate percentages for rolled-up data. So I want to make sure it sums the numerator and denominator separately before performing the division. If I do this as a variable will it work or will it perform the division on each record and then sum the result (which would give an incorrect answer)? Is it different if I do it in the report itself?

Thanks.

craiggsmith (BOB member since 2009-06-01)

2

BO does not handle two phase calculations, except at the report level, or by making the measures database delegated (version 3 and above).

Its best to create your numerator and divisor as summable universe objects and peforming the division / percentage as a report level variable.

If you do it in the SQL, you result will only be correct at run time and not when you slice and dice.

Mak 1 :uk: (BOB member since 2005-01-06)

3

OK, thanks very much!

craiggsmith (BOB member since 2009-06-01)