Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Business Objects, an APPARENTLY simple COUNTER ....

 
   Database Help (Home) -> OLAP RSS
Next:  Filesize problem  
Author Message
Luca

External


Since: Feb 08, 2005
Posts: 1



(Msg. 1) Posted: Tue Feb 08, 2005 11:24 am
Post subject: Business Objects, an APPARENTLY simple COUNTER ....
Archived from groups: comp>databases>olap (more info?)

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,
Cool

 >> Stay informed about: Business Objects, an APPARENTLY simple COUNTER .... 
Back to top
Login to vote
youvegottobeki

External


Since: Sep 24, 2003
Posts: 4



(Msg. 2) Posted: Fri Feb 11, 2005 7:40 am
Post subject: Re: Business Objects, an APPARENTLY simple COUNTER .... [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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.DeleteThis@energee3.com (Luca) wrote:

 >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,
 > Cool

 >> Stay informed about: Business Objects, an APPARENTLY simple COUNTER .... 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
MicroStrategy Report grouping by two different dates - Hello: I need to do a MicroStrategy report like that: Year Items by DATE-1 Items by DATE-2 --- --------------- --------------- 2005 43 30 2004 124 96 2003 112 ...

Reducing Processing time of large catalog/cubes over the n.. - I have a catalog that we are do a full process on which consists of 7 cubes with about 75 millions rows of data(total). This catalog takes about 6 hours when processed locally. Recently we moved our datamart to another site(than the analysis server),..

Documeting Cognos Reportnet solution - Have been trying to find some best practices for documenting a reportnet based solution. We have recently upgraded to Cognos Reportnet and intend to rationalise and move over several reports which are running on impromptu to Reportnet. The problem I am....

MDX - Returning a fixed value - Hi , I need to create an MDX query that will return the value 0, is it possible to do this without the use of measures/dimensions etc? As an example what I want to recreate is the SQL below using MDX: select sum(sales), 0, 0 ,0 ,0 from SalesTable My....

Average function and MSSQL Analysis services - Hi All This should be pretty simple I think, but I can't make it work: Using MSSql 2000 with Analysis Services I have created a cube. In this cube I want to have a measure or calculated member that gives me the average instead of the sum. My data..
   Database Help (Home) -> OLAP All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]