A pleasant Monday to everyone:
I need to count the number of instances of the object (call it . If I ‘avoid aggregation’, I get exactly one. What I really want is the value of the object and the count.
=Count() yields 1.
=Count(Count()) gets the correct value but only if I get back all the rows.
Am I making sense?
JayBob
Listserv Archives (BOB member since 2002-06-25)
Jay Ide wrote:
I need to count the number of instances of the object (call it . If I ‘avoid aggregation’, I get exactly one. What I really want is the value of the object and the count.
=Count() yields 1.
=Count(Count()) gets the correct value but only if I get back all the
It depends on the object category (dimension/Measure) and the computation context…
count(measure) gives you the “number of measures=rows” in the corr. context, count(dimension) gives he no of distinct values…
DI Walter Muellner
Delphi Software GmbH, Vivenotgasse 48, A-1120 Vienna / Austria Tel: +43-1-8151456-12, Fax: +43-1-8151456-21 e-mail: w.muellner@delphi.at, WEB: http://www.delphi.at
Listserv Archives (BOB member since 2002-06-25)