Count expression

[#1]

Hi,

I need to count the values different of 0 (zero) in a specific column. I have tried different ways like Count(Planned), Count(Planned <> 0), but they didn't work as should be?

Any clue?

Thanks

[#2]

Try

=COUNT(IF(Planned <>0,Planned))

or

=COUNT({<Planned -={'0'}>}Planned)

[VishalWaghole]

Hello Eric,

You can use this expressions,

=count({<Planned = {' * '} - {' 0 '}>}Planned)

or

=count({<Planned -= {' 0 '}>}Planned)

- Regards,

Vishal Waghole

[#4]

Thanks Clark...both of them worked

[#5]

Thanks Vishal....both of them worked