Business Objects, an APPARENTLY simple COUNTER ....

#1

Dear all,
we have problems with a formula for an apparently simple counter.

This is the formula

=TotalCount(If (<valore test(Query)>) = 0 Then 0 Else 1)

It seems that the "= 0" is worthless
because it gives the same results as the "<> 0".

Please help us, this is the last issue of a complex report, and the rest is OK !

Thanks in advance,
8)

#2

Count(0) will surely be same as Count(1).
Don't you really want to Sum() ?

On 8 Feb 2005 10:24:06 -0800, lovasto (AT) energee3 (DOT) com (Luca) wrote:

Quote:

Dear all,
we have problems with a formula for an apparently simple counter.

This is the formula

=TotalCount(If (<valore test(Query)>) = 0 Then 0 Else 1)

It seems that the "= 0" is worthless
because it gives the same results as the "<> 0".

Please help us, this is the last issue of a complex report, and the rest is OK !

Thanks in advance,
8)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Business Objects, an APPARENTLY simple COUNTER ....

comp.databases.olap comp.databases.olap

Business Objects, an APPARENTLY simple COUNTER .... - 02-08-2005 , 12:24 PM

Re: Business Objects, an APPARENTLY simple COUNTER .... - 02-11-2005 , 05:31 AM