How to Prevent BO from returning only distinct values

building reports webintelligence
1

Hi,

We are taking the average of a certain column but whenever there is a duplicate BO seems to discard the second value and calculate the average without it.

For example if i have the following records:

0, 0, 4, 2

Then the average is returned as 2 rather than as 1.5, how can i force it not to do this ?

thanks

krdghart (BOB member since 2009-05-01)

2

Go into properties for that report block, and check the box for “Avoid duplicate row aggregation”.

mobrien :us: (BOB member since 2004-03-03)