BusinessObjects Board

Object Properties

Hi,

What is the difference when we create a measure. In the Select part we say count(ID’s) and in the properties tab we select sum(default).

When we run a query. Does it do the count of sum of the ID’s?

I am confused :expressionless: :expressionless: :expressionless: :expressionless: :expressionless:


eye_candy :us: (BOB member since 2005-03-18)

Please, see post on Measures: SQL aggregation & projection.


Andreas :de: (BOB member since 2002-06-20)

When you look at the SQL generated it will be select count(id) from table… so, it will count the ids.


BOXIER (BOB member since 2010-02-07)