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
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.