Related to the use of Count and Count All

building reports desktopintelligence
1

I am unable to decipher the syntax error in the formula below, can someone point it out to me?

=CountAll(<MSISDN(Query 3 with Recurrin)>) Where (( “02”))

The bold portion is where BO points out that the Syntax error is!

I also face problems when i insert a formula in a cell where the formula uses Count or CountAll. It behaves erratic, sometimes i get the correct value and sometimes just “1.00” !! I have tried using Count(ToNumber… thinking it could be a problem due to datatype, but not with much luck.

Looking forward to some enlightened answers… Cheers… GB

gbramk6 (BOB member since 2003-08-07)

2

Try:

=CountAll ( <MSISDN(Query 3 with Recurrin)> ) 
  Where ( <Recharge Type> = "02" )

Andreas :de: (BOB member since 2002-06-20)

3

Or if you’re trying to compare greater-than, the “>” that you have is the end-delimiter for the variable, so yo need another “>”, like so:

=CountAll ( <MSISDN(Query 3 with Recurrin)> ) 
  Where ( <Recharge Type> > "02" )

Anita Craig :us: (BOB member since 2002-06-17)

4

Which I believe will not work, because the WHERE operator in BO Reporter only accepts the equal “=” sign.

For a workaround regarding this specific problem, please see BO Reporter FAQ.

Andreas :de: (BOB member since 2002-06-20)

5

Thanks for that, Andreas – I wasn’t thinking about that – my first thought on viewing the syntax was that gbramk6 might be using a “>” and not realizing that was the end-delimiter for the variable.

Anita Craig :us: (BOB member since 2002-06-17)