Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try
=COUNT(IF(Planned <>0,Planned))
or
=COUNT({<Planned -={'0'}>}Planned)
Hello Eric,
You can use this expressions,
=count({<Planned = {' * '} - {' 0 '}>}Planned)
or
=count({<Planned -= {' 0 '}>}Planned)
- Regards,
Vishal Waghole
Thanks Clark...both of them worked
Thanks Vishal....both of them worked