Syntax Problem.

building reports desktopintelligence
1

Hi All,

I have inserted a new row and I am trying to using the following formula on BO 5.0

=If Amount>=1 and Amount<=100 then Count(Amount)

I am getting #COMPUTATION Error. I have 50 records with amount range between 1 and 100. I would like to count all these records and give a single number. Can’t we use aggregate function in if then statement? Any suggestions are welcome.

Thanks
Ravi.

______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

Listserv Archives (BOB member since 2002-06-25)

2

try

=if(>1 and <= 100) then CountAll()

businessobject@HOTMAIL.COM 03/07/00 11:06AM >>>
Hi All,

I have inserted a new row and I am trying to using the following formula on BO 5.0

=If Amount>=1 and Amount<=100 then Count(Amount)

I am getting #COMPUTATION Error. I have 50 records with amount range between 1 and 100. I would like to count all these records and give a single number. Can’t we use aggregate function in if then statement? Any suggestions are welcome.

Thanks
Ravi.

______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

Listserv Archives (BOB member since 2002-06-25)

3

Hi Ian

Unfortunately it doesn’t work out. I am getting same #Computation error. Please give me some other solution.
Thanks
Ravi.

Date: Tue, 7 Mar 2000 11:11:57 -0700

try

=if(>1 and <= 100) then CountAll()

______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

Listserv Archives (BOB member since 2002-06-25)

4

Shouldn’t there be an else?

Brent

From: Ian Humphries <Ian.Humphries@POWERQUEST.COM

Date: Tue, 7 Mar 2000 11:11:57 -0700

try

=if( >1 and <= 100) then
CountAll()

Listserv Archives (BOB member since 2002-06-25)

5

Shouldn’t there be an else?

My experience is that you don’t need an else. If you leave it off, then the results are NULL if the condition is false.

Michael Welter
Sr. Technical Analyst
AirTouch

Listserv Archives (BOB member since 2002-06-25)