Count

[Former Member]

Hi friends,

I need to count, the values in the report.

Name

-

-

-

-

B

A

Z

Count=3, but i am getting count=6; Because i am using Count[Name];All), so it is correct, But i don't want to count the '-' in the name. So i tried

If ([ Name]<>"-";Count([Name];all);0) ,but i am getting mutivalue error.

Can any one suggest!

Thanks lot,

Regards,

-B-

[former_member212749]

Hi Balaji

Try some thing like this

if (countall(name="-"));0;1)

Regards

Prashant

[Former Member]

Hi Prashant,

Thank you for your reply.

I solved the problem Using where condition,

Count(Name);All) where(Name) not equal to"-")

I am getting correct result.

Thanks again for helping

Thanks lot,

Regards,

-B-