Hi,
I am using Business Objects ver 4.1/Oracle.
I have a problem when counting a field of number or characters and one of
the records is null, when looking at the database through the “view” option
I can see the value is “#empty” however the count functions count these
records as well.
Do you have any Idea how to cope with that?
Thanks,
Ronen Baran
MIS, Tecnomatix
Tel: 972-9-9594856 Fax: 972-9-9544402
Listserv Archives (BOB member since 2002-06-25)
Count works differently on and objects! for measures you
always get the number of “rows” returned including empty values (not sure about
that), for dimensions you get the number of distinct valus (excluding emt values).
hope this helps.
Walter
Ronen Baran wrote:
Hi,
I am using Business Objects ver 4.1/Oracle.
I have a problem when counting a field of number or characters and one of
the records is null, when looking at the database through the “view” option
I can see the value is “#empty” however the count functions count these
records as well.
Do you have any Idea how to cope with that?
Thanks,Ronen Baran
MIS, Tecnomatix
Tel: 972-9-9594856 Fax: 972-9-9544402
Pls report bounces in response to postings to BUSOB-L-Request@listserv.aol.com
Web archives (9am-5pm ET only): listserv.aol.com/archives/busob-l.html
OR search: Mail to listserv@listserv.aol.com, ‘search a_phrase in BUSOB-L’
Unsubscribe: Mail to listserv@listserv.aol.com, ‘unsubscribe BUSOB-L’
====================================
–
DI Walter Muellner
Delphi Software GmbH, Vivenotgasse 48, A-1120 Vienna / Austria
Tel: +43-1-8151456, Fax: +43-1-8151456-21
e-mail: w.muellner@delphi.at, WEB: http://www.delphi.at
Listserv Archives (BOB member since 2002-06-25)