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